Elettracompany.com

Компьютерный справочник
5 просмотров
Рейтинг статьи
1 звезда2 звезды3 звезды4 звезды5 звезд
Загрузка...

Функция now в access point qlikview

Красивый и понятный Access Point в QlikView и Хаб Qlik Sense

Для разработчика Qlik нет ничего красивее, чем разработанное им самим приложение. Но пользователям не всегда удобно ориентироваться в Access Point QlikView (ну или Хабе Qlik Sense) по мини-дэшбордам, которые предлагает Qlik по умолчанию.

Чтобы упростить навигацию для пользователей по доступным приложениям в Access Point, мы воспользовались стандартным функционалом QlikView, который почему-то редко используют. Ничего сложного и сверхъестественного в этой «фишке» нет, но, надеюсь, кому-то будет полезно. Ну и бонусом – как то же самое сделать в Qlik Sense, хотя там это как раз это более очевидный функционал.

Красивый Access Point в QlikView

Когда пользователь заходит в стандартный Access Point QlikView, он видит что-то подобное:

Спустя некоторое время, привычка подсказывает, на какую иконку кликать, но можно сделать красивее и удобнее. Тем более, что много времени и сил это не отнимет.

Настроить кастомные иконки для приложений в Access Point очень просто:

  • Заходите в Параметры – Свойства документа .qvw
  • Выбираете раздел «Opening» (Открытие) — «Document Thumbnail» (Эскиз документа) – прикрепляете желаемую картинку в «Image»:

Вот, например, что получилось у нас:

Совет: Как вы можете заметить, в иконках мы используем не только надписи, но и цвет. Например, для дэшбордов – фиолетовый, для приложений по бизнес-областям – зеленый, для отчетов с детализацией всех проводок – синий, с корзиной покупок. Для пользователей это привычно и удобно, рекомендую подобный подход.

Картинки мы загружаем размеров 433*244 пикселя. Доступные форматы: .bmp, .png, .jpg, .jpeg, .gif.

Красивый Хаб в Qlik Sense

В Qlik Sense настройка собственных иконок для отображения в Хабе гораздо более очевидно, так что, думаю, многие уже используют эту возможность. Но вот инструкция на всякий случай:

  1. В обзоре приложения зайдите в раздел «Изменить»:

  1. Кликните на иконку с картинкой, чтобы заменить изображение:

  1. В библиотеке медиафайлов выберите нужное изображение:

Добавить файлы в библиотеку медиафайлов можно по адресу: C:UsersИМЯ_ПОЛЬЗОВАТЕЛЯDocumentsQlikSenseContentDefault (это дефолтная папка, если вы ее не изменяли)

  1. Нажмите «Вставить», а затем на галочку, чтобы прекратить редактирование.

Совет: Изображения лучше подбирать с такими характеристиками:

  • Соотношение высоты и ширины – 5:8
  • Форматы: png, .jpg, .jpeg, .gif

На сегодня – все. Хорошего юзабилити вашим Access Point-ам и Хабам Qlik! =)

QlikView Web Server (QVWS) – Service, Load Balancing, Access Point

by DataFlair Team · Updated · November 14, 2018

Keeping you updated with latest technology trends, Join DataFlair on Telegram

1. QVWS – Objective

Another pivotal service in QlikView is the QlikView Web Server (QVWS). QlikView Web Server plays a central role in the workflow of QlikView. In this QVWS tutorial, we will venture further into understanding the web server and the processes linked to it. We will learn how to configure Web Server in QlikView, about load balancing, access point etc.

So, let’s start QlikView Web Server Tutorial.

QlikView Web Server (QVWS) – Service, Load Balancing, Access Point

2. What is QlikView Web Server?

The QlikView Web Server (QVWS) and QlikView Server (QVS) works in close coordination. QlikView Web Server provides support to the front-end. Web servers come with the server installation package, although the server also provides individual web server requirements if/when needed. The most important role of QlikView Web Server in the QlikView architecture is to act as a middleman between the QlikView Server and the client. The data traffic coming from QlikView Server is directed to the QlikView Web Server component (QVWS or Microsoft IIS) at some point. As we already know from the previous tutorials that a Windows client connects directly to the QVS but if the client is an AJAX or a mobile client, then they connect to the QVS through QVWS (Web Server).

One much-preferred web server is Microsoft Internet Information Service (Microsoft IIS). It provides functionalities like authentication schemes, better flexibility, and connectivity and improved web services for applications other than the server. A unique functionality call as QlikView Setting Service for handling management calls in Microsoft IIS. However, the default web server is QlikView Web Server and not Microsoft IIS when you install the software. It is your choice whether or not you want to keep using QVWS as the web server or switch to Microsoft IIS.

Let us take a quick look at some of the technical details of QVWS,

The location of the executable file is-

A data file is located at, %ProgramData% QlikTechWebServer.

The protocols used are HTTP: 80; HTTP: 4750; SNMP: 4751

It controls Directory name service.

We use it by QlikView Management Service.

3. Service Provided by QVWS

There are various services that a QlikView Web Server provides, we will discuss each pointwise-

QlikView Web Server manages the Access Point back end as all the documents that are distributed through QlikView Server reached the QVWS and then goes to the access point at the frontend.

Directs the incoming traffic between transfer protocols. It sends data to and receives data from the QlikView Server according to the scheduled communication sessions.

Читать еще:  Как убрать красное подчеркивание в powerpoint

Manages the load balancing of the server cluster of QVS.

It can also serve static data if/when required.

The authentication process of authorized windows user manages by QlikView Web Server.

Custom user authentication can manage by QVWS.

4. Configuring Web Server

The settings and configuration files can access from the location C:ProgramDataQlikTechWebServer. The configuration file is titled ‘Config.xml’. You can either configure the server through QlikView Management Service or can do it manually by adding a script in the Config.xml file which specifies the details of configuring the server accordingly.

5. Load Balancing in QlikView Server

The load balancing of the QlikView Servers do by QlikView Web Server. It is different from the usual load balancing because here it does not matter which server the user’s document request directs to because the resources equally consume. In the table attached below are some load balancing schemes mentioned. You can configure the load balancing setting from QlikView Management Console.

Random – This is the default load balancing scheme. In this user is sent to a random server, regardless of the fact that the document the user is looking for is loaded or not.

Loaded Document – In this scheme, when a particular document is loaded on a single QlikView Server, then the user is sent to that QVS only. If more than one QVS or no QVSs has the document loaded, in that case, the user is sent to the QVS with the largest amount of free RAM.

CPU with RAM overloaded – In this scheme, the user is sent to the least busy QlikView Server.

6. QlikView Access Point

One more important function of QVWS is hosting web pages and documents requested by the user. It also prepares a list and stores the information about all the user documents to be available on QlikView Access Point. It is a web platform where the user can view and access the documents, available both in a thumbnail or a detailed list view.

QlikView Web Server (QVWS) – QlikView Access Point

QVWS Tutorial -QlikView Access Point

Also, there are different settings options like category, attribute for the document grouping. You can access these options from Documents>User Documents>Document Information. You can also get information like when the documents were updated last or when will they update next. You can see the file size of a document, check the client details by clicking on a document.

So, this was all about QlikView Web Server Tutorial. Hope you like our explanation.

7. Conclusion

Hence, we studied about QlikView Web Server, its services, load balancer, and configuration web server. If you wish to know about anything related to QVWS, feel free to drop your queries in the comment section below.

Related Topic – QlikView Sheet and Object

QlikView Section Access for defining data access in your applications

New age BI tools like QlikView and Tableau are making it easy to access information on the go. With this ease of access, there comes an additional danger – the danger of putting the application in wrong hands. Imagine what can happen if your QlikView application (which stores and presents information for all business critical decisions) falls in wrong hands!

Data Security is one of the top concerns for any Organization, more so for data driven Organizations.

In order to gaurd against this danger, QlikView (& now QlikSense) come with Section Access – a way to decide who can view what information, which objects can be viewed by whom and from which domain etc. These can also be set with help of QlikView publisher. In this article, we will discuss section access and show how it can be applied to a QlikView application.

What is Section Access?

It is a feature used to control the security of QlikView applications. Section access is defined as part of the load script, where we define an authorization table, i.e. a table where you define who gets to see what information and from where. Section access can be of various types, depending on the sensitivity of the information and business comfort:-

  1. A simple username and password might be sufficient to access some documents
  2. In some scenarios, you would want specific users in your domain to be logged in specific machines and use certain keys to unlock the information.
  3. You may also want to restrict access to specific objects and sheets of a document.
  4. Remove fields from the data model for the specified user (by omitting them).
  5. Row level data reduction based on authorization mentioned.

In this article, we will cover row level data reduction only and rest of the methods will be discussed in future posts.

Facts before Implementing Section Access:

Here are some basic rules to remember before implementing section access:-

  1. Backup your application because Incorrect syntax will render your document inaccessible and there’s no possibility of recovering the data or script.
  2. Section access data (Security table) loaded by an external source (xlsx, txt …) must be loaded by using upper case in the SECTION ACCESS statement.
  3. Security table contains several user-specific system fields, like USERID, PASSWORD, ACCESS are basic system fields. You can also combine several fields to build the Section Access solution depending on the desired level of security. (To know more about System fields, please refer QlikView Reference Manual).
  4. Apart from the standard fields, additional fields can be defined to administer data reduction for each user.
Читать еще:  Конвертер dbf access

Problem:

For Sachin Dashboard (we had created this application as a tribute to Sachin’s test career), I want to restrict users to see his performance against a particular country only. Look at below security table, it defines the permission to user.

You can see that we have defined 10 users with userid, password, level of access and value for field AGAINSTCOUNTRY, for which these users require access. One of the key things, I want to discuss in the above table is, “*” in Section Access. “*” denotes all values i.e. users, who have access to see all values listed in the table. If a value is not listed in the security table, it will not be available to anyone.

For ACCESS, we have two access levels “ADMIN” and “USER”. ADMIN has privileges to change everything in the document and controls what “USER” can see in the document.

Implementation of Section Access:

Now let’s Implement this section access to an existing document. We will perform this in following steps:-

  1. Create a copy of existing document because if any thing goes wrong, we have a backup.
  2. As we know that we are going to apply restriction on row level data based on Against_Country field, so first let’s make sure that it is available in UPPER case. Here, I have converted it to upper case (Changes done to the original table).
  3. Add a new tab and write script to import Security table followed by Section Access statement using inline table or external file. (We are doing this with external file).
  4. Save document and then go to Setting —> Document Properties —> Opening tab and turn check box on for “Initial data reduction Based on Section Access” and “Strict Exclusion”.
  5. Save it and reload. Close the dashboard after the reload.
  6. Now Open dashboard, here it will ask for User Identification and based on your user permission you will be able to see the results.
  7. Here, I have given USERID and password of Kunal and i am able to see Sachin Test Career summary only for the country Australia (as mentioned in Security table).

End Notes:

In this article, we have seen an example of how to restrict user to row level data limitation using Section Access. We also looked at what are security feature we should look at while developing or delivering dashboard. I recommend you to apply security feature to document before sharing it with any one.

In future, we will also discuss about other security features like NT domain identification, document properties (Sheets, Object), field level security. It also provides an example of how naming conventions can be used to architect a solution that is more robust and lowers maintenance costs for your QlikView documents.

QlikView по-русски

Цель блога — дать русскоязычному сообществу пользователей QlikView возможность получать информацию о продукте на родном языке

Страницы

Поиск

Облако ТЭГов

Архив

  • авг 2013 (1)
  • авг 2012 (2)
  • июл 2012 (2)
  • июн 2012 (1)
  • ноя 2011 (4)
  • окт 2011 (2)
  • апр 2011 (1)
  • фев 2011 (2)
  • ноя 2010 (1)
  • июл 2010 (1)
  • июн 2010 (4)
  • дек 2009 (1)
  • окт 2009 (2)
  • сен 2009 (4)
  • дек 1983 (1)

19 сентября 2009 г.

Переменные в QlikView

13 комментариев:

Спасибо
Обновляйте блог, очень мало информации

согласен, мало. Что-то я совсем забросил это дело. Буду пытаться наверстать упущенное. 🙂 Вот еще бы понять что именно интересно, о чем так сказать в первую очередь хочется почитать.

ПримерX: Показать.
не работают ни в одном из браузеров
пофиксите плиз

не работают ссылки на примеры

Да, спасибо. После смены дизайна много чего полетело 🙁 Исправил.

«Обозреватель переменных, то увидим в качестве значения строку ‘=1+2’ (см. скриншот выше). Однако, если мы используем эту переменную s, например, в объекте Text Object, то в результате мы получим вычисление формулы описанной в переменной s и в Text Object’е мы увидим цифру 3.»

за это отдельно большое спасибо!

Ищу инструктора по QlikView.
Нужно с нуля научиться пользоваться программой в сжатые сроки. Обучение возможно по скайпу или стационарно. Цены и условия готов обсуждать.
+79032778572

Добры день. Только начал изучать QlikView, подскажите пожалуйста, как можно переопределить переменную.
Пример:
Есть переменная, при загрузке полей в зависимости от условий, она должна принимать разные значения.

Читать еще:  База данных студентов access скачать

Приветствую. Не очень понял вопрос. В любом случае, чтобы переопределить значение переменной в скрипте вы можете использовать операторы LET или SET (разница описана в данном посте)

Ну вот ну например:
Если я объявлю переменную, а потом при загрузке полей как переопределить?

SET перем = «Текст»,

поле1,
поле2,
поле3,
IF (Поле1 = 1, перем = Поле2, перем=Поле3) as Поле4

Ну вот как-то так. Подскажите как это правильно реализовать в QV?

Так делать нельзя. переменная это не массив значений, там можно хранить только одно значение. После выполнения LOAD вы можете рассчитать одно значение, но не для каждой строки таблицы (как вы пытаетесь). Не ясна цель конечная, поэтому сложно что-то подсказать. возможно вам нужно определять значение переменной не в скрипте, а уже в дизайне (Layout) в зависимости от текущей выборке по «поле1».

Добрый день. При загрузке данных из текстового файла значения одного из атрибутов указывается со скобкой, из за особенностей текстового файла. Пример:
123(
2224(
12(
Вопрос. Как можно убрать скобку? Что прописать?

Павел, здравствуйте.
Вариантов масса.
1) Left(FieldName, Len(FieldName)-1) as FieldName
2) purgechar(FieldName, ‘(‘) as FieldName
3)SubField(FieldName, ‘(‘, 1) as FieldName
и др.

Функция now в access point qlikview

Ye ‘nj kturj ghjdthbnm

� Advanced Analytics Integration � server-side extensions (SSE) can be used to extend the expression framework with support for calling third-party engines. You can configure a server-side extension to extend the built-in expression library, both for load script and for chart expressions with external calculation engines.
� Web Client Improvements � The Internet Explorer Plugin is not being developed further. As such, considerable work was done to ensure feature parity for the AJAX client. Specifically, the following capabilities have been included in this release:
� Switch language — End users can now choose UI language in the Profile settings in AccessPoint
� Detach — The Detach option is found in the right-click menu for any chart object. When a chart is detached, subsequent selections will not be applied to the object until it is re-attached. This functionality enriches the analysis possibilities, allowing users to exclude a desired subset of charts from the selections.
� Set reference — The Set Reference option is found in the right-click menu for Bar, Line, Combo, Gauge and Scatter charts. When Set Reference is selected for a chart object, the current data display of that chart is permanently shown as a dimmed view alongside the subset of data visualized after a selection is made. This feature provides new ways to compare data.
� Copy single column selection — This functionality is now available in List Box.
� Copy cell — This functionality is now available in List box, Straight Table, and Pivot Table.

� Shared File Management Improvements � A new structure and transaction handling for shared files has been implemented. These improvements will drastically reduce the risk of corrupted files in high-traffic scenarios. Additionally, a new method of cleaning shared files to remove inactive users has been implemented which can drastically improve server performance.
� Export to XLSX (vs XLS) � XLSX is now the default exporting format for Excel files, replacing XLS.

� KML Support — QlikView can now read KML files for use in a map visualizations. The KML file can represent either area data, such as countries or regions, or point data such as cities or places.
� Continued On Demand App Generation Enhancements � The option for developers to include the app navigation link UI into a web mash-up. And, the ability to ensure that the generated app utilizes the same SSO for authentication back to the data system. Currently this is possible wtih SAP Hana and Cloudera.
� Update to Quote Interpretation in Set Analysis � An update is being made to the Qlik Associative Engine which changes the way that quotes are interpretted in set analysis. In short, single-quotes are utilized for literal interpretation of the items enclosed within them and doublequotes are evaluated and allow for the use of such things as wildcards.
� This change ensures that set analysis interprets quotes in the same way as other areas of the engine and is consistent with our documentation and best practices. However, some developers may have incorrectly utilized the single quote in places that should have double quotes and this enforcement of the intended use will cause issues in these cases.
� Apps created in prior versions will not need to be updated as the system will respect the old method for these apps. However, customers may opt to force all apps to respect the new rules.
� This change (using single quotes for literal values) allows for the ability to support case sensitive search strings in Set Analysis

Ссылка на основную публикацию
ВсеИнструменты 220 Вольт
Adblock
detector
×
×