Qlik Geocoding is a subscription service for address to coordinate lookups and vice versa. The service is hosted, address and key get sent to remote servers for lookup. The subscription has a limited amount of lookups and is valid for one year. Qlik Geocoding is an add-on service to Qlik GeoAnalytics Base and Qlik GeoAnalytics Enterprise Server. The service is provided through the Qlik GeoAnalytics Connector using the operations “AddressPointLookup” and “PointToAddressLookup”. Forward geocoding is address to point conversion. The result includes information about match level and location structure. Reverse geocoding is point to address conversion. Useful for example converting GPS coordinates to an location.

To get started

1. Please contact your Qlik sales rep for pricing and license key.
2. Watch the Qlik Geocoding Presentation
3. Download the Qlik Geocoding Template
4. Start converting addresses!

Below you will find templates for use together with the Qlik GeoAnalytics connector for Qlik Sense and QlikView. And also a template for GeoOperations (to be used in QCS and QSEoK).

(Qlik Sense Server only, Qlik Sense Desktop has no Repository)

There are situations where you would like to know something from the system configuration (QMC) from inside of a load script, something like "Which custom attributes does my app have assigned?" Or "Which stream is the current app in?" I've seen the "bad" idea to connect to the Postgre repository database and read from the internal table structure. This internal structure may, and is likely to, change, so I would not build on this hack.

The correct way to do it is to use the QRS API (Qlik Repository Service). In theory, the QRS API operates on the https port 443 as well as on port 4242. If you used the latter, you have to present the public key of the server certificate, which cannot be done from the load script (remark added 2020: the REST Connector meanwhile allows to add a Certificate File and Key File, so you can setup a connection directly to port 4242 when allowed from a firewall point of view).

In order to use the port 443, you need to authenticate as a privileged user towards the server - your best bet from the script is to use the header authentication (pass the userid via http-header) and this requrires the setup of a Virtual Proxy on the server by a QMC admin.

1. Setup a new Virtual Proxy with Header Authentication
2. Use Postman or another tool to test the qrs endpoint response before going to the load script
3. Load Script: Use REST Connector with CONNECTION parameter

Step 1 - Setup Virtual Proxy

We want the script to be able to query the QRS api, so we have to give it a new "door" to authenicate. Set up a new Virtual Proxy like this: There will be a static pseudo user directory which we call "APIUSERS", whereas the user id itself will be provided in a http-header.

Dont forget to

• add the Server node(s) under "Load balancing"
• link this virtual proxy to a Proxy in the "Associated Items".

Note: We will have to come back to QMC/Users once again after making the first call using the header.

Step 2 - Test the qrs endpoint with header authentication

It is literally impossible to go straight to the REST connector from the script if you haven't tried the results from a tool that shows all response details (return code, possible error messages etc). My tool of choice is "Postman" (the app, not the Chrome-Plugin of the same name)

Lets use the server url + /header/ (this is the virtual proxy we created) + /qrs/about + &xrfkey= and a 16 digit combination, which you repeat in the http-headers under the key "X-Qlik-xrfkey" again. Also provide the userid as a 2nd http-header

You should get an answer like above in Json format. This means, you made it through the virtual proxy. A new user has been added to the QMC, namely the id "scriptload" (coming from the http-header) with the directory "APIUSERS" (coming from the virtual proxy setting).

Go back to the QMC and provide the new user the Role "AuditAdmin"

Now you can also query some details about the app. Try the following request, before we finally go to the Load Script. -.../qrs/app/full should provide all information about apps, including possible tags.

In order to get the details about one specific app you should use the "filter=" query-string, the syntax is like the Json object key, a comparison operator, and a constant. In my case: id eq <app-guid>

eq is "equals", don't use "=" which is a reserved character already used at "filter="

If this works fine, lets edit the app script.

3 - Create REST Connector call from Load Script

Go to the app's dataload editor and create a new connection of type "REST".

The principle I follow here is:

1. get over the initial dialog with hard-coded query-strings and http-headers to get the qrs call working (same Method as later, GET for GET, POST for POST)
2. load the data once
3. manipulate the created script with "WITH CONNECTION" argument and soft-code all the parameters to make it dynamic

Then load the data using the "Select Data" button in the Data connections list:

You can expand the Json response tree and deselect what you don't need. Be aware that each tree branch, which expands, will become a separate script table, so be conservative with what to load using a "need to know" judgement.

Insert the script. You will see the block called "RestConnectorMasterTable: SQL SELECT ..." and then several LOAD statements (in our case 4, one for the root and 3 childs which we selected above)

Until this point, the script is fully static. It only loads exactly this QRS endpoint and always load all apps.

Now lets bring some dynamics in. Find the last row of the first block where it reads FROM JSON (...) "root" PK "__KEY_root";

Before the semicolon insert (in a new line) WITH CONNECTION ()

With this parameter you can soft-code and overwrite any hard-coded entry from the "Edit Connection" dialog. If you omit a parameter in WITH CONNECTION, the original hard-coded entry from the Edit Connection dialog will be taken. You can also add more parameters using WITH CONNECTION. Use the WITH CONNECTION script as follows:

• If you want to overrule the endpoint address use URL "https://...." option
• If you want to add another Query-string (filter for example) use QUERY "filter" "id eq cde61c53-b536-46f3-8538-6470042e4160" (QUERY takes 2 more parameters, key and value)
• If you want to add another header-key use HTTPHEADER
• Note: You can NOT change the method (GET/POST), you need another data connection if you have to use the other

Here is my example of getting the info just for the current app:

Add this row before the "LIB CONNECT TO ..." statement:

LET vAppId = DocumentName();

This will assign the app GUID to the variable.

Modify the last row of the first block as follows:

FROM JSON (wrap on) "root" PK "__KEY_root"

WITH CONNECTION (

URL "https://qmi-qs-aai/header/qrs/app/full"

    ,QUERY "filter" "id eq $(vAppId)" 

);

Note: the variable $(AppId) is slided into the filter. QUERY xrfkey;

When you execute the script, you will get the app info from the QRS API loaded as a table datamodel:

Now you can use some of your scripting skills to get, for example, to check which tags the given app has and do something:

FOR v = 1 TO FieldValueCount('name_u0')

    LET vTag = FieldValue('name_u0', 1);

    IF vTag LIKE 'byCSW' THEN

        TRACE --- this app has the tag of the tags ---;

    END IF

NEXT v

More Advanced Script Example or QRS API

In the following example I am loading the list of all tasks for a given app. For the tasks I also want a 1:n-List of Custom Properties (if any) and Tags (if any). The returned Json structure would be complex (8 tables for the qrs endpoint /qrs/reloadtask/full):

Deselect what you don't need. I also unchecked a lot of unneeded columns. You better spend a few minutes in the "select data" dialog of the Data Connector than in the script below.  To see which fields I skipped I commented them out in the code below. I also introduced "nice field names" like "tag.name" or "task.id" instead of auto-generated names such as "name_u4", "id_u6" ...

Finally, I joined some tables to have only 3 relevant ones after this.

Here is the sample script:

LET vAppId = DocumentName(); LET vXrfkey = Left(KeepChar(Repeat(Rand(),10),'0123456789'), 16); TRACE Onetime Xrfkey = $(vXrfkey);     LIB CONNECT TO 'QRS full app info (qmi-qs-aai_vagrant)';     RestConnectorMasterTable: SQL SELECT    "id" AS "id_u6", // "createdDate" AS "createdDate_u0", // "modifiedDate" AS "modifiedDate_u0", // "modifiedByUserName" AS "modifiedByUserName_u0", // "isManuallyTriggered",    "name" AS "name_u2",    "taskType",    "enabled", // "taskSessionTimeout", // "maxRetries", // "privileges" AS "privileges_u5", // "schemaPath" AS "schemaPath_u0",    "__KEY_root",    (SELECT    // "id" AS "id_u0",    // "createdDate",    // "modifiedDate",    // "modifiedByUserName",       "value",    // "schemaPath",       "__KEY_customProperties",       "__FK_customProperties",       (SELECT       // "id",          "name",       // "valueType",       // "privileges",          "__KEY_definition",          "__FK_definition"       FROM "definition" PK "__KEY_definition" FK "__FK_definition")    FROM "customProperties" PK "__KEY_customProperties" FK "__FK_customProperties"),    (SELECT       "id" AS "id_u1",       "name" AS "name_u0",    // "appId",    // "publishTime",    // "published",    // "stream",    // "savedInProductVersion",    // "migrationHash",    // "availabilityStatus",    // "privileges" AS "privileges_u0",       "__FK_app"    FROM "app" FK "__FK_app"),    (SELECT    // "id" AS "id_u5",       "name" AS "name_u1",    // "privileges" AS "privileges_u4",       "__FK_tags"     FROM "tags" FK "__FK_tags") FROM JSON (wrap on) "root" PK "__KEY_root" WITH CONNECTION (    URL "https://qmi-qs-aai/header/qrs/reloadtask/full"    ,QUERY "filter" "app.id eq $(vAppId)"    ,QUERY "xrfkey" "$(vXrfkey)"    ,HTTPHEADER "X-Qlik-Xrfkey" "$(vXrfkey)" // ,HTTPHEADER "userid" "scriptload" );         [root]: LOAD    [id_u6] AS [task.id], // [createdDate_u0] AS [createdDate_u0], // [modifiedDate_u0] AS [modifiedDate_u0], // [modifiedByUserName_u0] AS [modifiedByUserName_u0], // [isManuallyTriggered] AS [isManuallyTriggered],    [name_u2] AS [task.name],    [taskType] AS [task.taskType],    [enabled] AS [task.enabled], // [taskSessionTimeout] AS [taskSessionTimeout], // [maxRetries] AS [maxRetries], // [privileges_u5] AS [privileges_u5], // [schemaPath_u0] AS [schemaPath_u0],    [__KEY_root] AS [__KEY_root] RESIDENT RestConnectorMasterTable WHERE NOT IsNull([__KEY_root]);     LEFT JOIN //[app]: LOAD    [id_u1] AS [app.id],    [name_u0] AS [app.name], // [appId] AS [appId], // [publishTime] AS [publishTime], // [published] AS [published], // [stream] AS [stream], // [savedInProductVersion] AS [savedInProductVersion], // [migrationHash] AS [migrationHash], // [availabilityStatus] AS [availabilityStatus], // [privileges_u0] AS [privileges_u0],    [__FK_app] AS [__KEY_root] RESIDENT RestConnectorMasterTable WHERE NOT IsNull([__FK_app]);     [customProperties]: LOAD // [id_u0] AS [id_u0], // [createdDate] AS [createdDate], // [modifiedDate] AS [modifiedDate], // [modifiedByUserName] AS [modifiedByUserName],    [value] AS [customProp.value], // [schemaPath] AS [schemaPath],    [__KEY_customProperties] AS [__KEY_customProperties],    [__FK_customProperties] AS [__KEY_root] RESIDENT RestConnectorMasterTable WHERE NOT IsNull([__FK_customProperties]);     LEFT JOIN //[definition]: LOAD // [id] AS [id],    [name] AS [customProp.name], // [valueType] AS [valueType], // [privileges] AS [privileges],    [__KEY_definition] AS [__KEY_definition],    [__FK_definition] AS [__KEY_customProperties] RESIDENT RestConnectorMasterTable WHERE NOT IsNull([__FK_definition]);       [tags]: LOAD // [id_u5] AS [id_u5],    [name_u1] AS [tag.name], // [privileges_u4] AS [privileges_u4],    [__FK_tags] AS [__KEY_root] RESIDENT RestConnectorMasterTable WHERE NOT IsNull([__FK_tags]);       DROP TABLE RestConnectorMasterTable; DROP FIELDS [__KEY_definition], [__KEY_customProperties];

Have you ever noticed, when you have the same app open twice and make selections, those selections are reflected in all your open tabs? This is because they are all open using the same session/identity.

This has been one of the most requested features by our users as they like to compare things side by side, without changing the selections every time, or having to build charts with alternate states.

Luckily, there is a way to bypass this using the Qlik Single integration API.

The Single Integration API provides parameters that can be used to create an URL that returns a complete HTML page containing for example an embedded Qlik Sense visualization. This URL can be embedded in a web page, for example by including it in an iframe.

Here's how :

1. Open your desired app multiple times
2. In the first tab, add this parameter at the end of the URL: /identity/1 (The 1 is alphanumerical and can be longer than 1)
3. In the second tab, add this parameter /identity/2
4. Repeat this step for every other tab you have opened

Voilà! You are now able to make different selections for the same app!

If you are reading this and perhaps don't even know what a Dynamic View is, don't worry, you are in good company. It's been perhaps one of Qlik's best keep secrets. 

Not sure why so many have kept it a secret but you know I'm an open book. I want you, or specifically your end users, to have access to all of the goodies and Dynamic Views is certainly one of those. 

If you do know what Dynamic Views are then stay here and watch the video to see that Dynamic Views are still very much supported in Qlik Sense Enterprise SaaS. In fact, if anything you may see that the code to implement has gotten even easier. Then feel free to read the blog I wrote for DataOnThe.Rocks. 

If you are not familiar with Dynamic Views then read the blog first. That way before you start thinking about implementation you understand WHAT Dynamic Views are and WHY I think so highly of them and what they offer your end users. Once you understand the concept and the consumption then the video is your next step. 

Dynamic Views Blog

Welcome to the QS CSS MasterClass.

Motivation:

In my career as a PreSales, I need to create quite a few "user-appealing-applications". Sometimes users request a specific design or specific functions I need to implement in Qlik Sense. As we all know, Qlik Sense is built for simplicity & self-service and sometimes it could be challenging to achieve the desired result. But through the last couple of years, there were a lot of tips and tricks around using CSS to create completely new designs and functions to implement a better information design concept.

This is where the MasterClass starts. I have created an application that gathers a couple of these tricks and explains them more in detail. In addition to that, it is very easy to understand because you can see the result directly within a Qlik Sense App. If you think this sounds interesting, take a couple of minutes and join my short tour through the app. I won't cover all aspects in detail. This tour will give you an overview of the documented and used tricks within the app.

Content:

The following list will give you a brief overview of what topics are focused on the specific sheet within the app.

Sheet	Description
Types of CSS implementation	You can add CSS definitions to your app by using themes or by using so-called "helper- objects". On this sheet, I will explain when you should use which option.
Hide (Helper-) Objects	A "helper-object" carries and injects the CSS definition on a specific sheet. This sheet helps you to hide this object and which objects can be used for it.
Colored Area Background	This example demonstrates how to add better guidance to your dashboards by segmenting your background.
Filter Pane Highlighting	Sometimes selections can be mandatory to consume a dashboard, or the creator likes to guide the user through the filter pane by using colored filter boxes. I show you how.
Hiding Button/Options	How to hide objects like the selection bar or elements within context-menus in case these functions shouldn't be used in the app or on this sheet?
Using Background Pictures	Adding background-pictures to your dashboard can spice up the overall flavor of your dashboards. This can be used for segmentation or just to add some style.
Table modifications	In this section, we will completely change the look and feel of a straight- and pivot table.
Moving Objects	Let's create an illusion by just moving our objects closer together. After that, I'll look like we just have one.
Changing standard fonts	This sheet explains the easiest way to implement your own font by using a custom theme. It's just a few lines of code.
Custom Grid Layout	No matching grid? This trick shows you how to create your own grid for a specific sheet by changing the metadata through Qlik Engine API Explorer.

Installation:

Under "Attachments" you can find the required package. The zip package includes a qvf file (Qlik Sense - CSS MasterClass V 1.0.qvf) and an extension (ShowHTMLfromMeasure). After importing the extension and app we need to change a quick configuration because the app has a different ID on your system now.

Open sheet called "Using Background Pictures". Normally this sheet has a background image. This gets referenced over the internal app-ID. Click on "Edit Sheet" and select the displayed CSS box ("CSS config HERE"). Navigate to submenu "Styles" and change the used app-ID in "Styles (CSS)" to your app-ID (displayed in the URL). Now you should see a background picture on this sheet.

Usage:

Every sheet has the same structure. First, a description explains the trick in general and how it's working. On most of the sheets, you also get the explanation for the used CSS selectors. On the right-hand side, you can see the used code in a black code box. You can't copy the code from here. To do so enter the "edit-mode" and click on the "CSS config HERE" button. This object is always the "Helper-object" that carries the used and explained CSS code. Navigate to the "Styles" submenu and copy the code from the "Styles (CSS)" window. I recommend using an external editor to modify or review the CSS code.

In case you like to transfer the trick to your dashboard you just need to change the object ID. If you don't know how to find the object ID this will be explained on sheet "Hide (Helper-) Objects".

In December 2022 I posted one Visualization tip for Qlik Sense per day until Christmas Eve.

Here's the app with more details for each tip.

1. Pareto chart
2. Count combinations
3. Sunburst chart
4. Show all values
5. Parallel coordinates
6. Copy to slide deck
7. Arc Chart
8. Control Chart
9. Annotations
10. Patterns
11. Sort by first measure
12. Chord Chart
13. Sheet background
14. KPI Cards
15. Bulls Eye Chart
16. Fixed color classes
17. Unbalanced trees
18. More points in scatter
19. Slope Chart
20. Org Chart
21. Overview first
22. Fine grid
23. Lexis
24. Animations

If you liked it, here's more tips in the same style:

• 24 days of Visualization 2021
• Sense Visualization tips part VI
• Sense Visualization tips 2021 part V
• Sense Visualization tips 2020 part IV
• Sense Visualization tips 2020 part III Qlik World
• Sense Visualization tips 2019 part II
• Sense Visualization tips 2019 part I

Similar but for Qlik GeoAnalytics :

• Qlik GeoAnalytics tips 2020 QlikWorld
  
• Qlik GeoAnalytics tips 2019 Qonnections
• Qlik GeoAnalytics tips 2018 Qonnections

Thanks,
Patric

Monitoring current performance and availability of Qlik Sense site is not out-of-the-box feature, but can be easily achieved with native REST connector and requesting engine\healthcheck JSON API.

There are other tools and approaches, but since I already have the best BI tool available 😉, I found it reasonable to use it. All that is necessary is just:

1. download and import the attached app
2. create REST Data Connections and adjust the settings in the script
3. schedule app reload

This Qlik Sense app:

• loads engine\healthcheck JSON data from multiple nodes
• parses and consolidates it to two tables
• stores them to QVDs with all previous snapshots
• visualizes key metrics of engine utilization and availability in time

It's recommended to deploy and schedule this app on DEV or TEST site, pointing to all production nodes. Otherwise, there will be no data loaded in case the production engine (or the whole server) crashes.
(just FYI - DEV and TEST sites are included in the professional license subscription)

It's also recommended to read the official help site info about the engine API before you deploy this app.

After importing the app to a suitable site, follow these steps:

1. Decide on target folder for result QVD files, where parsed snapshot of JSON data will be stored. Create a folder Data Connection (if it doesn’t already exist) and set its Lib name to vQVDpath variable in Settings script section.

2. Create a REST Data Connection to each node:

URL: https://<server domain>/engine/healthcheck OR https://<node IP address>:4747/engine/healthcheck

Authentication Schema: Windows NTLM
User name & password: type root admin or service user credentials
check "Skip server certificate validation" if there is no valid certificate on target node

Query headers:
User-Agent: Windows
Cache-Control: no-cache

3. Adjust the INLINE table in the Settings section of the script according to your site

node - name of the node that will be shown for app’s user
restConnection - name of the REST connection that points to node’s engine/healthcheck
RAM - amount of node's memory in GB
CPU - number of node's logical processors

4. Schedule a reload task. The recommended app reload frequency is 5 minutes or less (tested reload duration on the 4-node site is 12 seconds). The script will return "N/A" in [isSaturated] field when the engine is not responding.

The current roadmap includes - script for email notifications, possibility to load only N days back, mapping app name to IDs, node comparisons.

PLEASE! If you make adjustments or additions to the script or front-end visualizations, please share them back on the Qlik Community.

Happy Qliking 🙂
-RADO-

QGA can consume geodata from many different sources including Esri ArcGIS online, here's what's needed to show the data as a feature layer in QGA.

Step-by-step guide

Start by figuring out the correct parameters. In this case the source is administrative boundaries (Buurt) of the Dutch city Zwolle.

1. Usually an base url is given like this (https://services1.arcgis.com/3YlK2vfHGZtonb1r/ArcGIS/rest/services/Zwolle_WijkBuurt_gdb/FeatureServer/0), follow and click on "Query" at the bottom
2. Set parameters Where 1=1, Outfield BRTNR (this is the field we want to use as index) in, and set the output to geojson and clicked Query (Get)
3. Try out the the geojson in geojson.io, realise that projection needs to be 4326 (WGS84), changed the url param : outSR=4326.
   
   Note! If you want to use the builtin basemap, the geojson layer should be in WGS84 -> EPSG:4326
   
   
4. And voilá a valid geojson url! https://services1.arcgis.com/3YlK2vfHGZtonb1r/ArcGIS/rest/services/Zwolle_WijkBuurt_gdb/FeatureServer/0/query?where=1%3D1&objectIds=&time=&geometry=&geometryType=esriGeometryEnvelope&inSR=&spatialRel=esriSpatialRelIntersects&resultType=none&distance=0.0&units=esriSRUnit_Meter&returnGeodetic=false&outFields=BRTNR&returnGeometry=true&returnCentroid=false&multipatchOption=xyFootprint&maxAllowableOffset=&geometryPrecision=&outSR=4326&returnIdsOnly=false&returnCountOnly=false&returnExtentOnly=false&returnDistinctValues=false&orderByFields=&groupByFieldsForStatistics=&outStatistics=&resultOffset=&resultRecordCount=&returnZ=false&returnM=false&quantizationParameters=&sqlFormat=none&f=pgeojson&token=
5. Check that the geojson works by setting it up as a static geodata layer.
6. Then make a area layer with the geojson as input, BRTNR as dimension.I checked the geojson and used BRTNR as the "Source key attribute".
   
   
   See the attached Sense app for more details. Note 1, this example requires Qlik GeoAnalytics. Note 2, this app features data from an external service which might be out of service.

Authentication in ArcGIS

Special note regarding Authentication in ArcGIS (Thanks to ssamuels for the solution)

The authentication when working with secured map services from ESRI can be solved by setting up a REST connection in the loadscript to retrieve a new access token from the REST API of ArcGIS Online. This is done by sending a GenerateToken request to the URL "https://www.arcgis.com/sharing/generateToken?parameters".  The REST call must be a POST request over https and takes the following parameters:

username - Username of the user who wishes to get a token.

password - Password of user who wishes to get a token.

referer - The base URL of the web application that will invoke the services

expiration - The token expiration time in minutes (default value for this parameter is 60 minutes)

f - The response format. The value for this parameter must be "json".

The resulting access token is stored in the data model and can be used as a text variable to append to the location service url in the GeoAnalytics extension.

This post explains how to connect to an Oracle database using the OLE DB connector and a tnsnames.ora file.

• Download the latest version of the Oracle Database Client for Windows (x64). You can use this link or Google it.
• Unzip the file and double-click on setup.exe.
• Select custom installation and follow the installation instructions.

• Choose an intallation folder (E.g., C:\oracle).

• Select components Oracle Net, Oracle ODBC Driver and OLE DB.

• Click on Next and finish the installation.
• Type environment variables in Windows' search bar and open the app. Then, click on Environment variables.

• Create a user variable named TNS_ADMIN and set its value to the path of the folder where your tnsnames.ora file is located.

• Open Qlik Sense and create a new OLE DB connection. In the Data Source textbox, type the name of the connection as it is in the tnsnames.ora file.

Sense Map chart

Example adding a WMS background

1. Add in Content Security Policy (Qlik SaaS)
Origin: nowcoast.noaa.gov Directive : connect-src and img-src
2. Add Map chart
3. Add background layer WMS
url: https://nowcoast.noaa.gov/arcgis/services/nowcoast/radar_meteo_imagery_nexrad_time/MapServer/WMSServer
version:1.3.0
crs: EPSG:3857, transparent, png, layer: Image

Note, use CRS 3857 if the base map has the Mercator projection (default).
Pick CRS 4326 if the base map has the Adaptive projection.

Link to documentation and example.

(QGA Extension map, old kept for reference)

Start by figure out the correct parameters. In this case the source is a WMS with data from the Dutch city Zaanstad.

Note, the urls below has chnaged and not working anymore, principles still applies)

1. Easiest way to pick up the WMS source and at the same time verify that it works is through a demo page,
   for example http://geo.zaanstad.nl/mapproxy/demo/?srs=EPSG%3A28992&format=image%2Fpng&wms_layer=Zaanstad
2. Select CRS (coordinate system), 4326 for use together with the default adaptive basemap or 3857 with the defualt basemap. Right click on the map image and "Open image in new tab..." . Copy the image url:
   http://geo.zaanstad.nl/mapproxy/service?LAYERS=Zaanstad&FORMAT=image%2Fpng&SRS=EPSG%3A28992&EXCEPTIONS=application%2Fvnd.ogc.se_inimage&TRANSPARENT=TRUE&SERVICE=WMS&VERSION=1.1.1&REQUEST=GetMap&STYLES=&BBOX=77018.328125,474244.265625,153485.671875,512224.734375&WIDTH=1208&HEIGHT=600
3. Remove the following parameters (these are filled in by the map) : BBOX, WIDTH, HEIGHT, VERSION, SRS.
   That produces the url to use: http://geo.zaanstad.nl/mapproxy/service?LAYERS=Zaanstad&FORMAT=image%2Fpng&EXCEPTIONS=application%2Fvnd.ogc.se_inimage&TRANSPARENT=TRUE&SERVICE=WMS&REQUEST=GetMap&STYLES=
4. Fill in CRS and VERSION (in my example EPSG:3857 and 1.1.1 check the WMS url for the version).
   
   Pro tip, "Load via Server" is practical to use if the the WMS doesn't allow CORS.
   
   Pro tip 2, run Sense in the browser (http://localhost:4848/hub/my/work) and use the dev console (F12), good to spot errors from the WMS server.
   
   

Hi All,

As we all know Qlik Analytical Platform is quite new in market. People are still in confusion as what QAP is, how it is different than Qlik Sense Enterprise. How to configure QAP Server, Manage QAP and especially what exactly the output of QAP. There are lots of tickets which give you chunk of information like difference between QAP and Qlik Sense Enterprise, how to reload on QAP server when there is no HUB under QAP but there is nowhere how to configure a QAP solution from scratch to end with details.

This document guide you to know what QAP is , how it is different than QSE, setup QAP Server, create and publish Mashup(Embed Analytics ) a, manage QAP Objects and reload application on QAP when there is no HUB at all.

Question: Why Qlik Sense client needs QAP ?

Answer:

1. QAP is for external users simply which doesn't need self service or QSE capabilities.
2. DMZ network where external users are not allowed to access application from internal network.
3. Client doesn't want to buy hundreds of Qlik Sense tokens for such users which don't need deep analysis.
4. No certain details of Qlik Sense end users like users count, user details(anonymous).
5. Embed Qlik Sense objects in client’s web portal like any news paper, public portal etc.

QAP setup needs knowledge of Qlik Sense Enterprise (server configuration with security rules) and web developer  skills (css and java script and basic HTML) who will help you to embed Qlik Object to web portal.

I have attached one QAP product presentation, you may start with it then below tutorial video so you have enough functional knowledge of product. 

Important  video tutorial of QAP:

Let’s start from beginning:

Difference b/w Qlik Sense Enterprise and Qlik Analytical Platform:

In principle QAP and QSE is same but in general QAP is subset of QSE means QSE without HUB(No Self Service). QAP is a solution of embed analytics. If no self service is there in QAP it means no "create things" but still developers can create visuals by APIs.

Https://HostName/hub you can view the application but when you open it, it will give you an error you don't have access pass, it means you can't view any apps object on hub.

QAP enables you to display sheet or charts into your website.

Commercial difference, QAP has core based license model dislike QSE which has token based license model (It means no user and login passes, which means you just need to grant the access to users or authorized users to the content which is embedded in web portal )

Recently Qlik introduced core bases license for self service too.

QAP is intended for using our APIs (Extensions, Mashups etc.) to deploy custom solutions.

The Qlik Sense client is disabled in QAP (when you will login to hub you would view the streams and apps but when you will click on any app, it will give you error of access passes).

It has same installation package as QES but applying a QAP license key will disable hub it means you can view the hub, streams list, and application icons but apps objects like sheet, charts, measures and dimensions will not open on HUB. It will give you an error, you hve no access passes.

QAP license policy: when a client buys a QAP token, it comes with minimum 4 cores, it means no matter how many cores or virtual processors are available on deployment server, it will only consume or utilize 4 core among all available cores. So, let’s say client's server has 8 cores or 16 logical processors on Qlik Sense Enterprise server and your application size is 1 GB and you are planning to use same application on QAP, So when you import this application to QAP, It will not work as it works on QSE sever cause QAP(as per the license capacity) will consume only 4 cores out 8 cores and your 1 GB application need 8 cores to perform or load objects like QSE.

Note: Do not be confused, what will happen when you will activate the Qlik Server with QAP license, you will get everything same i.e. QMC as Qlik Sense Enterprise but there will be no Tokens means you can't create any user or login pass which we use to authorize users to access the Qlik Sense content.

To implement QAP server, configured it security with custom properties so you would manage security of data for users with

https://community.qlik.com/docs/DOC-18066

These 9 points will create a stream, import the application and publish the application to the newly created stream and grant access to application and app objects.

Try to use Dev-Hub to view the object i.e single configurator.

Now, we will add one more new security rule which will grant all the users to access the APIs like extensions, mashups, Widget, Single configurator.

***You may create one new custom property QAPExtension with resource type Extension and User and the create a new security rule with Extension Template and write a security rule as:

((User.@QAPExtension=resource.@QAPExtension))

Then go to the extension by Click one start => Extensions => select your extension(Mashup) => go to custom properties and click on the Space bar and select the value you have given while creating Custom properties do the same exercise for users too .

Now, we don’t need to create any custom property because QAP is for all users (no limit) above activity started with *** is when you created a mashup and then you need to provide access of some particular Extension(Mashup) to any specific users.

So, for QAP, write a simple security rule as with template Extension:

((user.name="*" or resource.name="*"))

Which means all user will access the all the APIs (extensions, mashups, Widget, Single configurator).

Often, People ask what if my client hasn't any web portal so in that case above Mashup solution will work, Mashup is kind of website(.html file) or web solution.

This is best with Qlik comes Sense as we can create a HTML page with our Qlik Objects so easily(Basic HTML and JS  and CSS knowledge requires).

Now point comes, if all user will come how to secure the data, here comes the real QAP solution,

Generally what QAP says, create an application on Qlik Enterprise or Desktop, import on the QAP server and publish its Objects to client website (Mashup is a HTML page but it’s not a web portal).

So above, you have imported an application, created stream, published application, granted access to all users. What is left now, go to single configurator, select one object, there will be two links come on top side, Iframe and URL, Copy anyone and go to the website page where you need to show these objects and paste it(Please take the help of web developer because every object needs a proper space and alignment).

If any user who is not authorized to view Qlik objects but has rights to login web portal where Qlik Sense objects embedded then it will show an error, so you may ask your web designer to handle this case and put any image instead of INVALID OBJECT message from Qlik Sense.

Now when any user will come it will see an error, access denied or ask for credentials , so You may configure the single sign on here ,Please refer the very useful document for single sign on :

https://community.qlik.com/community/qlik-sense/support/blog/2016/05/11/qlik-sense-ticket-based-authentication-step-by-step-configuration-example

Last Point, how to manage the QAP server application. I mean, reload and all. So, You can’t open any application on QAP HUB and there will be no script editor so how to reload if you have imported the application from Qlik sense enterprise:

If you have imported the apps from another Qlik Sense Server the required data connections are unfortunately not imported together with the qvf-file. That is probably why the tasks fail since the data connections are missing. Check in QMC > Data Connections if they are there and if they are properly set up.

Please refer this article to reload data in QAP: https://qliksupport.force.com/articles/000025412

” When you import an app developed on Qlik Sense Desktop, existing data connections are imported to the QMC. When you export an app from a server, existing data connections are not exported with the app.”

Since the QAP is a Qlik Sense-server without the "hub" and aimed for integration purposes only you have to find a way to import the data connections into the QAP QMC for reloads to work. One way could be to create an empty app in Qlik Sense Desktop with the required data connections and then import this qvf into the QAP. Then you can manage and set up the imported data connections properly in the QAP QMC.

Reach to me for further assistance, Please drop an email to kumar.rohit1609@gmail.com

Add me on Linked In : https://in.linkedin.com/pub/rohit-kumar/2b/a15/67b

Add yourself on Qlik intellectuals page on Facebook at https://www.facebook.com/QlikIntellectuals

Please like this page or add as bookmark and add your ratings so my I will know how effective my solution is for Qlik Users.

You may add your queries below so I would come up with solution. I will try to keep update this document with more powerful inputs. Your queries and inputs will help me to improve the quality of this solution. The aim is to make a perfect document which will guide you to a perfect solution.

This application is a tool that we use to create Proof of Concepts very quickly. The idea is simple. You upload the data you want to visualise and a spreadsheet of meta-data which defines dimensions and measures. The application template then takes care of the rest.

This video shows this in action:

If you would like to download this application and use it with your own data you can download it from here:

https://www.quickintelligence.co.uk/isa

I hope you find the application useful and as much of a time saver as we do.

A tutorial blog post giving some pointers as to how to build the components in this app, using only standard Sense features, can be found here:

https://www.quickintelligence.co.uk/instant-qlik-sense-application/

I hope that you find the application useful. You will find other applications that I have uploaded under my profile on QlikCommunity or on our Downloads page..

Steve

I like mathematics and see the potential it is not only in robotics or “almost sci-fi” technologies but everywhere where data is generated and should be understood.

I like Qlik, its possibilities and simplicity for end-users at the same time.

However, when it comes to mathematics and Qlik together, a lot of people think about SSEs – python or R – and default Qlik math functions are underestimated. I think there might be two reasons – Qlik users do not know about them or do not understand when these functions can help them. So, I decided to develop a Qlik app that will get you an overview of default mathematical functions in Qlik with a little bit of theory and above all, examples and exercises. All of them are interactive – thanks to Qlik 😉.

In the QS Math & Statistics app v3.0 you can find:

• Quiz to test your skills with Qlikculator I am very proud of 😄 (what to do for 5 hours in a train without wifi)
• An interactive overview of basic math functions with examples
• Descriptive statistics – theory, example, and my thoughts:
  • Measures of central tendency
  • Measures of variability
  • Percentiles, quartiles, fractiles
  • Measures of distribution
  • Overview of different datasets
• Intro to correlation
• Financial functions
  • Overview with the Payment calculator
  • Future Value & Present Value

If you will find the app useful, in next versions I will add:

• Outliers & extreme values – why and how to identify them
• Financial aggregation functions (IRR, NPV, XIRR, XNPV)
• Linear regression with examples not only for prediction
• Combinatorics examples
• Statistical distribution functions

Thanks, @radoresky  for your help and review of the app 

I hope you will like it. Any recommendations are very welcome 😉,

Maria

Today, I'd like to share with you our current App backup solution using Powershell and Qlik-Cli.

As you know, a production environment needs backups and Qlik Sense Enterprise does not offer such a thing by default so I decided to build a solution.

Using Qlik-Cli for Windows, I put in place a solution that will not only backup my published and unpublished apps but will also create a folder structure to match your streams.

The unpublished apps are backed up inside the "My Work" folder using the app owner's name as a directory name. This allows to easily find the app owner when performing a search in the folders.

Square brackets in the App's name will be removed because you cannot create a file with these characters in Windows.

The script is scheduled using the Windows Task Scheduler with the following command:

Here's the code:

$ErrorActionPreference = "Stop"

Try
{
# set export drive and directory
D:
cd D:\QlikBackups

# connect to the Qlik Server. Replace <ServerName> with your Qlik Sense hostname
Connect-Qlik -ComputerName <ServerName> -UseDefaultCredentials -TrustAllCerts

# Export each apps from the previously defined streams to qvf
Get-QlikStream | % {New-Item -Name ".\$($_.name)" -Force -ItemType 'Directory'} | foreach {Get-QlikApp -filter "stream.name eq '$($_.name)'"} | foreach {Export-QlikApp -skipdata -id $_.id -filename "$($_.stream.name)\$($_.name -replace '[[\]]','').qvf"}

# set the export folder to the My Work area for unpublished apps
cd "D:\QlikBackups\My Work"

# Create a folder structure for all the app owners
Get-QlikApp -full -filter "published eq False" | % {New-Item -Name ".\$($_.owner.userId)" -Force -ItemType 'Directory'} 

# Export each app into their folder
Get-QlikApp -full -filter "published eq False" | foreach {Export-QlikApp -skipdata -id $_.id -filename "$($_.owner.userId)\$($_.name -replace '[[\]]','').qvf"}
}
Catch # In case of error, send an email to the Qlik administrators
{
    $ErrorMessage = $_.Exception.Message
    $FailedItem = $_.Exception.ItemName
    $Time=Get-Date
    "Error: $FailedItem Message: $ErrorMessage Time: $Time" | out-file d:\log\QlikBackup.log -append
    
    $FailMailParams = @{
To = 'qlikadmin@MyCompany.com'
        From = 'MyQlikServer@MyCompany.com'
        Port = '25'
        SmtpServer = 'smtprelay.MyCompany.com'
        Subject = 'MyQlikServer Backup Failure'
        Body = "The backup failed. The error message was: $ErrorMessage"
        }

         Send-MailMessage @FailMailParams
}

My next steps are:

• Add timestamps to the filename
• Keep the most recent copy and Archive the rest.
• Add qvf file retention