An API key is required to authenticate each request to Google Maps Platform. Refer to http://g.co/dev/maps-no-account for more information.

An image used as a background in a chart does not load correctly. This can be observed when a proxy is configured in the client machine. 

Images are accessible from a browser, without using any kind of authentication and Web Server Logs do not contain any errors.

Resolution:

Manually add the following parameter (WebFileUseWinAPI = 1) in the Settings.ini file.

By default, the Settings.ini for QlikView Server is located at C:\ProgramData\QlikTech\QlikViewServer\Settings.ini
For QlikView Desktop is located in C:\Users\<User>\AppData\Roaming\QlikTech\QlikView\Settings.ini

1. Stop QlikView Services
2. In the [Settings 7] section in Settings.ini, add the setting WebFileUseWinAPI = 1
   eg.
   [Settings 7]
   WebFileUseWinAPI = 1
   [....]
3. Start QilkView Services

Please note that WebFileUseWinAPI = 1 setting must be entered under the [Settings 7] section. If the setting is added under the [Authentication] section, it will not be read by the QlikView Server, and will therefore not resolve the issue.

OR consider changing the proxy requirements: 

• Disable proxy setting (please contact network team to do this). 
• Add exception to default URL (http://maps.googleapis.com) to fetch image for google map in proxy server (please contact network team to do this)
• Use secure protocol (HTTPS) to fetch google images dynamically, rather than http. Example: https://maps.googleapis.com/maps/api/staticmap?center=

In Qlik Sense onPremise and Qlik Sense Cloud, the multi KPI bundle extension has an horizontal view (by default).

However, in Qlik Sense SaaS mobile, the horizontal view is lost.

Environment

• Qlik Sense SaaS Mobile

Resolution

Bug QB-16997 was closed by R&D as WAD because Qlik Sense SaaS mobile doesn't support horizontal view of multiple KPIs

In order to document this known limitation, a documentation bug HLP-13861 was reported to R&D.

Information provided on this defect is given as is at the time of documenting. For up to date information, please review the most recent Release Notes, or contact support with the ID HLP-13861 for reference.

Cause

Product Defect ID: HLP-13861 and QB-16997

Viewing a Qlik Sense app with the mobile client (on prem) causes the view to sometimes change from mobile to browser view.

Reviewing the "About" details shows the Qlik Sense Server's Version instead of the Qlik Sense Mobile client version.

Environment

• Qlik Sense Enterprise on Windows
• Qlik Sense Mobile

Resolution

1. Turn on the .NET Web Sockets in the Qlik Sense Server as below. If Multinode, changes must be done on all the nodes.
   
   Path: "C:\Program Files\Qlik\Sense\Repository\"
   
   The default value is "false"
   

   <add key="EnableDotNetWebSockets" value="false" />

   Now, Set/Change it to "true"
   

   <add key="EnableDotNetWebSockets" value="true" />

2. If Multinode, make sure all the Qlik Sense Servers share the common TLS/SSL Cipher Suites:
   
   • TLS and SSL Support in Qlik Sense: How to configure Qlik Sense and TLS
   • Supported TLS and SSL Protocols and Ciphers
3. Reboot the Server/s.

Cause

There will be an open delay (>30 seconds) of the "qrsData" WebSocket that can be seen in the Developer logs:

2022-11-24 12:08:12,794-INFO [WEB] Web socket URL: wss://qlikserver1.domain.local/hub/qrsData =>void PresentationManagerImpl::notifyMessageFromJavascript(QString)

After a minute...

2022-11-24 12:09:13,356-INFO [WEB] [wss://qlikserver1.domain.local/hub/qrsData] - socket.onopen =>void PresentationManagerImpl::notifyMessageFromJavascript(QString)

Below error in Qlik Sense Server Proxy logs relate to TLS/SSL/Cipher Suites

The client and server cannot communicate, because they do not possess a common algorithm

Internal Investigation ID(s)

QB-17151

Due to a defect discovered in the Qlik NPrinting Engine (May 2022 SR2) in combination with Qlik Sense client-managed connections, we advise holding on upgrading Qlik NPrinting to the May 2022 SR2 version and instead upgrading directly to SR3 (Qlik NPrinting May 2022 SR3).

Impact

Only connections to Qlik Sense client-managed are impacted on the following Qlik NPrinting version:

Qlik NPrinting May 2022 SR2

Resolution

Upgrade to Qlik NPrinting May 2022 SR3.

Workaround

We strongly recommend upgrading to Qlik NPrinting May 2022 SR3 once available, rather than to the SR2 release. In case you have already upgraded to Qlik NPrinting May 2022 SR2, follow the recommended workaround.

1. Uninstall Qlik NPrinting Engine May 2022 SR2
2. Install Qlik NPrinting Engine May 2022 SR1
3. If the engine is offline on the Qlik NPrinting Web console interface:
   1. Remove the Qlik NPrinting Engine
   2. Readd the Qlik NPrinting Engine
4. Upgrade the Qlik Nprinting Server and Qlik Nprinting Engine to May 2022 SR3 as soon as the SR is released.

Internal Investigation ID:

OP-95779

Environment

Qlik NPrinting May 2022 SR2

The Thumbnail of a Qlik Sense App or a Sheet Thumbnail is not displayed correctly.

Instead of the image, a broken image is displayed:

Environment:

Qlik Sense Enterprise on Windows 

Resolution:

The proxy does not have access to the static content or static content was not correctly migrated after an upgrade. 

1. Verify if the Service Account has access to the Static Content folder. See Service cluster for information on where you can locate the folder. 
2. If the Service Account has access, verify if the image exists. 
   1. Go to the Qlik Sense Management Console
   2. Navigate to Apps
   3. Locate the App ID of the app showing the issues
   4. Go to the Static Content folder
   5. Review content in the App Content folder and verify that the image exists

The problem occurs with Qlik Sense tables containing a link pointing to an HTTP address. The link works in Qlik Sense also when the table is exported to Excel.
The problem occurs when the table in imported in an NPrinting HTML or Excel template. When the report is generated, the link points to a local temp local folder or it just shows the column label as simple text. So the correct URL is not reachable.

Environment

• NPrinting May 2021
• NPrinting August 2021
• NPrinting November 2021
• NPrinting May 2022 SR 1 and SR 2

Resolution

The problem will be completely fixed in NPrinting May 2022 SR3 and higher releases.
Affected users can ask for a specific patch that is already available contacting Qlik Support team. The patch is based on NPrinting May 2022 SR2. We recommend these users to upgrade to SR3 as soon as it is available. The upgrade will not require any preliminary steps and can be performed as any normal ones.
The fix brought some changes in the usage of the hyperlink to notice:

• The table/column/cell tag %%Link_Column%% must be directly added to the HTML reports. NPrinting automatically recognizes the hyperlinks and place them in the tags. Already existing HTML tags (i.e. <a href="%%Link_Column%%">label</a>) must be replaced with NPrinting tags in the reports.
• The "keep source formats" option can be enabled or disabled. This hasn't any effects on the hyperlinks.

Cause

The problem is due to a defect that has been fixed.

Internal Investigation IDs

OP-95758 and OP-95757

Exploring a Qlik Sense App with the option Always one selected value active removes the setting on the configured fields in the new environment. 

This is working as designed. See the Qlik Sense Online Help about Always one selected value. 

Environment:

Qlik Sense Enterprise on Windows 
Qlik Cloud 

The goal is to dynamically add images in a PixelPerfect report. In this example we will add country flags, that are stored as image files, in a PixelPerfect template.

Environment:

Qlik NPrinting 

1. Create a Qlik Sense app, or use an existing one, with a straight table that has a column with the country name and a column with the path of the image file of the country flag.
   
   
   
   
2. Create a Qlik NPrinting connection to that Qlik Sense app and refresh its cache.
3. Create a new PixelPerfect report and open it in Qlik NPrinting Designer.
4. Add the Qlik Sense straight table with the flag paths as a Level.
   
   
   
   
5. Create the new level detail band in the template
   
   
   
   
6. Drag and drop the country cell in the detail band and format it as you prefer. This will print the country name in the final report
   
   
   
   
7. From the right side Tool Box drag and drop a Picture Box object on the details band and increase its dimensions.
   
   
   
   
8. In the Picture Box left side properties expand the (Data Bindings) node and then expand the Image URL node.
   
   
   
   
9. Click on the Binding drop down menu, expand the object in the level and select the Flag column. This link the Picture Box object to the files with the flags thanks to their paths in the Qlik Sense straight table.
   
   
   
   
10. Set the Sizing as you prefer.
    
    
    
    
11. Run a preview
    
    

When running full load task, as part of the information for tables to be loaded, Replicate displays in the monitor screen under ‘estimated count’  the estimated number of rows that are to be loaded in the full load.

The information about 'estimated count 'is read by Replicate from db system table that holds statistics about the db objects. For example, in Oracle source endpoint, the ‘estimated count’ is the table cardinality that is retrieved from column NUM_ROWS that is part of Oracle system view ALL_TABLES that holds the number of rows in the table.

This Techspert Talks session addresses:

• How to maximize your dashboards
• Learn about exciting capabilities
• How to get the most from your visualizations

00:00 - Intro

01:06 - Simplified Authoring

08:02 - Dynamic Titles

10:04 - Adding Help using Containers

11:05 - Extending Sheets

11:44 - Show Condition

12:02 - Link apps with a button

12:46 - Using Table Indicators

14:13 - Sparklines

15:20 - Trellis Container with KPI Cards

17:14 - Custom Tooltips

19:49 - Using Dynamic Images with SVG for Custom Charts

22:15 - Q&A: How to build a Gantt Chart?

26:38 - Q&A: How to color odd rows?

27:41 - Q&A: Where can I learn about new capabilities?

29:14 - Q&A: Can we increase font size in chart?

30:09 - Q&A: Best way to customize apps?

Resources:

Sense Visualization tips apps

VI: 2022, 37 tips, V:  2021, 29 tips, IV: 2020, 32 tips,
III: 2020, 43 tips, II:  2019, 41 tips, I:   2019, 28 tips

Best of compilation: 24 days of Visualization

Same but for GeoAnalytics : 2020 (23 tips), 2019 (22 tips), 2018 (19 tips).

Financial Times Visual Vocabulary: #1 NBS, #2 Qlik only.

List of charts: “Let’s Make New Charts with Qlik Sense”

Patrik Lundblads Data Visualization blog

News about new releases: Qlik Product Innovation blog

What’s new demo app: https://demos.qlik.com/qliksense/WhatsNew

Q&A:

Coming soon...

Click here for video transcript

In a line chart, the x-axis field has missing values for some of the line fields. For example, a chart shows the selling data for different products each month. For some months, a product can have no data.
You may want to show this missing data as zeroes in the line charts, so for these months the line goes to zero, but it is not possible. The missing data are simply ignored and line chart just creates a straight line to connect the two most close points, even if there is missing data in the middle.
The chart is not responding to changes in options for "Missing Values".
No matter what is selected, "show as zeros", "show as gaps" or "show as connections" it is displaying as "show as connections".

So "show as zeros" and "show as gaps" seem not to work.

Environment:

Qlik Sense Enterprise on Windows 
Qlik Cloud 
Qlik Sense Business 

Resolution:

A good workaround is to avoid missing data, for example converting them -when it is possible- to zeros.

Cause:

In a continuous data model there is no way of knowing what the 'missing values' are, it depends entirely on the granularity of your data, e.g by day, by minute, by year etc. Without that information coming from engine we can't create gaps.

Line Chart color show differently when export from Qlik Sense story telling to power point.  

Replication Steps:

1. Take a snapshot at the Line chart in the dashboard.

2. Go to Storytelling, drag and drop the snapshot saved.

3. Go to the Download story as PowerPoint.

4. Click the download link after it is ready. The PPT file is downloaded. User notice the downloaded contents is having different color appearance with it original chart color.

Environment

• Qlik Sense all versions

Resolution

This is a "known limitation". The limitation is due to a third party library.

Cause 

The PDF and PPT exports for story elements with some transparency are flattened by the Aspose library.

This is the standard behavior when an alpha channel (transparency) is merged with a white background.

Welcome to Getting started with the Qlik Sense Cloud Hub and how to interact with an app. In this article, we'll cover the basics of how to navigate the Qlik Sense Cloud Hub and how to interact with the data provided in an app.

The example App used in the video and article (Beginner's Tutorial) can be downloaded from the Qlik Help site.

Environment

• Qlik Cloud 
• Qlik Sense Business 

Click here for video transcript

Here is a link to the referenced Qlik Help site page in the video:

Tutorial - Beginning with the Basics 

Opening the Qlik Sense Hub

1. You access the Qlik Sense SaaS hub through your tenant URL. Example: Tenantname.eu.qlikcloud.com.
2. Once successfully logged in, the hub will be presented:
   
   
   
   Note that you can customize your home view, but we will focus on opening apps and navigating an app in this article. 

Filter on the Hub and find your App

By default, the hub will show you all content available to you. This includes apps, charts, data, notes, and links. To begin filtering;

1. Click Catalog. 
2. Choose from Spaces available to you.
   
   

    

3. Open a space. In our example, we select Managed Spaces (available in Qlik Sense Enterprise on SaaS).
   
   
4.  Filter the space by using the Filters available in the top menu, or Search content. 
   
   You can also sort by Last modified, Last created, or in Alphabetical order, and switch between List view and Tile View.
   
   The filters allow you to filter by Types (Apps, Charts, Data, Notes, Links) and Owners.
   
   

   

5. Open your App

Navigating the App

1. The app will display a list of sheets available to you in the Public sheets section and My sheets section. 
   
   Right-clicking on sheets shows a number of options available to you (depending on your permission) level. Such as Make private, Copy, Paste, and Duplicate. 
   
   Note that in this article, we will not cover creating, copying, or customizing sheets. 
   
   

    

2. Open a sheet (we will open the Dashboard sheet in our example.)
3. You can navigate between sheets from inside an active sheet by either using the sheets menu or the navigational arrows to page forward and back.
   
   

    

   
   
   
4. Return to the App overview from the top-right menu.
   
   

    

5. Return to the Hub by clicking on the Qlik Logo 
   
   

    

Making selections

When you make selections, the colors of the values change accordingly. The characteristic Qlik Sense colors are green, white, and gray, and they represent the basic states: selected, possible, and excluded. To learn more about selections and their different states, see Selection states.

Depending on the visualisation used, different selection methods can be used, such as Click selection, Draw selection, Range selection, Lasso selection, Legend selection, and Label selection. For more information on each selection method available, see Make Selections.

Let's test some selections:

1. We select 2014 from a Filter Pane and Japan from the Pie Chart and then confirm by clicking the green checkmark. 
   
   This will select Sales Per Region in the Year 2014. 
   
   

    

2.  The Selections Toolbar allows you to remove, edit, and step through (forward and back) your selections. 
   
   For more information see Exploring with selections and the Learning Material Searching & Selecting Data.
   
   

    

3. Another way to select and explore data is to use the Smart Search available in the Selections Toolbar.
   
   Smart search is the global search tool in Qlik Sense, enabling you to search the entire data set in your app from any sheet in the app. 
   
   For more information, see Using smart search and the Learning Material Searching & Selecting Data.
   
   

This concludes the basics of navigating the Qlik Sense hub and how to interact with visualisations.

Related Content:

Advanced material is available on Help.qlik.com, as well as in our Qlik Continuous Classroom offering:

Navigating in the user interface 
Getting Started with Qlik Sense (Free Training)
Searching & Selecting Data (Free Training)
Create and Apply Bookmarks  (Free Training)
Build and Play Stories (Free Training)
Creating analytics and visualizing data 

The script

Table1:
LOAD DISTINCT
      Inline [
      Field1, Field2, Field3
      1, 2, 1
      2, 2, 1
      3, 3, 1
      4, 3, 1];
DROP FIELD Table1.Field1;

creates a table with 4 rows.  Some developers, especially if used to work with QlikView 11, would expect a 2 rows table. In fact, after  Field1 is dropped, we can expect that the DISTINCT keeps only the distinct values from Field2.
This article explains how DISTINCT and DROP FIELD work in such a case.

Environment

• QlikView 12 all versions
• Qlik Sense on Windows all versions
• Qlik Cloud

Resolution

We can follow the script execution to understand why a 4 row table is the logic result.

1. The LOAD DISTINCT will create a table with 4 rows, because Field1 has no repetitions. All the values in the inline list will be imported. The table will look like this in memory:
   
   

   Field1	Field2	Field3
   1	2	1
   2	2	1
   3	3	1
   4	3	1

2. The DROP FIELD command is applied after the table creation. It removes Field1 from the memory. Notice that it does not force a re-apply of the DISTINCT, so the table will look like this in memory:
   
   

   Field2	Field3
   2	1
   2	1
   3	1
   3	1

   
   It is expected to have a table with 4 row and 2 repeated values even if the DISTINCT was applied in the LOAD statement. This occurs because the DROP FIELD occurred at the end. By dropping  Field1, we just removed that column from the memory, which means that Table1 will not have distinct rows anymore.

3. It is possible to use a script like this to have the distinct check in the second part of the script :

   tmp:
   LOAD DISTINCT
   Table1.Field2,Table1.Field3
   resident Table1;
   
   DROP Table Table1;
   
   Table1:
   NoConcatenate Load
   *
   Resident tmp;
   
   DROP table tmp;

Cause

Combining DISTINCT and DROP FIELD can lead to unexpected result. The behavior has changed with respect to QlikView 11.

Internal Investigation ID

QV-2384

On IPAD & iPhone, Qlik Sense session ends immediately if a user minimizes the browser to switch to another application. Once back to Qlik Sense, the following error will be displayed

This issue started with the latest versions of Qlik Sense (starting approximatively with QS August 2021). It mostly happens when opening the app in safari web browser.

Environment

• Qlik Sense Enterprise 

Resolution

Bug QB-14264 was reported to R&D.

Information provided on this defect is given as is at the time of documenting. For up to date information, please review the most recent Release Notes, or contact support with the ID QB-14264 for reference.

Workaround:

R&D found out that the issue was related to an “Experimental Feature” in Safari, called NSURLSession WebSocket that was enabled in IOS 15.xx.

For workaround, disable NSURLSession WebSocket  from Settings > Safari > Advanced > Experimental Features

Cause:

Product Defect ID: QB-14264

When accessing the Qlik Cloud tenant through VPN, all vpn users are unable to download Qlik Cloud chart images and data with errors:

Something went wrong

or

something went wrong with

Resolution

Check with your cloud security provider and ask them to insert your Qlik Cloud tenant address into its access whitelist for your environment

Cause

Cloud-related security platforms such as zscalar.net block download of Qlik chart images and data.

Related Content

https://help.zscaler.com/zia

Internal Investigation ID

QB-14441

Environment

Qlik Cloud 

In Qlik Saas, when adding an image <URL>  https://play-lh.googleusercontent.com/ahJtMe0vfOlAu1XJVQ6rcaGrQBgtrEZQefHy7SXB7jpijKhu1Kkox90XDuH8RmcBOXNn as a column to a table,  we expected this to fail because it should require  "img-src" directive to be checked in "Content Security Policy".

However, the logo with image <url> above is displayed correctly (see logo dispayed as Dim1 column in below screenshot ).

Adding a new column 'Alpha' with image <url>  https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcTaANtept27EFdcIQ62k2W2VCkpXSq0iDxT4w&usqp=CAU  does not display the expected image.

Environment

• Qlik Sense SaaS

Resolution

From a close look to console tab (of dev-tool), we noticed that some image <urls> are recognized by default (see above attached screenshot). They do not require the use of directive "img-src ".

Refused to load the image '<URL>' because it violates the following Content Security Policy directive: "img-src 'self' data: maps.qlikcloud.com ibasemaps-api.arcgis.com cdn.pendo.io app.pendo.io pendo-static-5763789454311424.storage.googleapis.com data.pendo.io *.gravatar.com *.wp.com *.googleusercontent.com cdn.qlik-stage.com cdn.qlikcloud.com upload.wikimedia.org".

A documentation request HLP-13324 was submitted to R&D .

Cause

Product Defect ID: HLP-13324

As of writing this article, it is not possible to restrict what users have access to export data in Qlik Cloud.

Environment:

Qlik Cloud 

Related Content:

Downloading app content 

In this article, you will learn how to repeat the headers of a long table in a Word report.

Environment:

Qlik NPrinting 

1. Create a new Word report template as usual and open it with the Qlik NPrinting Designer. Add the source table in the Tables node.
   
   
   
   
2. Set the Show Header property of the table to Hide.
   
   
   
   
3. Drag and drop the table columns you want into the report.
   
   
   
   
4. Manually insert a row above the tags row by using the Word table tools. Enter the column headers and customize their appearance.
   
   
   
   
5. With the headers row selected, open the Word Layout -> Properties window. 
   
   
   
   
6. Open the Row tab and flag the Repeat as headers row at the top of each page check box.
   
   
   
   
7. Click on OK and run a report preview. The table headers will appear on every page.

The"Keep Source Formats" option has some limitations in NPrinting. One of them is about tables in Word reports.  Tables generated in a Word report with the "Keep Source Format" option active have no border. A user has to give up the table border in order to keep the original Sense formats.
This article provides a workaround to create Word tables with borders and source formats.

Environment

• NPrinting 2020 and higher releases

Resolution

Follow these steps to generate a Word table with borders and Source formats.

1. Import the entire table as level.
2. Drag the level in the Word template and drag the table columns between the level tags. Be sure that blank rows are removed .
   
   steps 1. and 2.
   
   
3. Add a table row at the top of the level and enter the titles manually. Be sure that blank rows are removed.
4. Use Word formatting options to customize the title.
   
   steps 3. and 4.

Here below an example of the result:

result example

Following this workaround it is possible to create a Word table with borders and Sense formatting. On the other side, there are some limitations to consider:

• The table header must be created and edited manually and it is possible that it is not identical to the Sense table header.
• The generation of levels requires more system resources and more time. Applying this workaround can slow down the performance of NPrinting especially when many tables are generated this way in a report and when one of this table is cycled by a page, by a cycle or by another level. Be sure that you keep the performance monitored.

Another option to customize tables in Word is to use the Word formatting as shown in this article.