When entering a condition for Cloud Alerts, the alert may not trigger if the value was entered without using the function (Fx) button.

Resolution

This is working as designed.

Two types of alerts can be designed:

• An alert based on a string
• An alert based on an expression

String

To generate an alert based on a string, directly enter the string in the value text box. 

Analyzing the value with the developer tool, it will be shown as a simple string:

Expression

To generate an alert based on an expression, click the function (fx) button and enter the required expression or value.

Analyzing the value with the developer tool, it will be shown as {qExpr: "…"}}].

Related Content

• Monitoring data with alerts 
• Tutorial - Alerts 

Environment

• Qlik Cloud Analytics

At Qlik Connect 2024 I hosted a session called "Top 10 Visualization tips". Here's the app I used with all tips including test data.

Tip titles, more details in app:

• New, recurring and lost
• Phasor diagram
• Common 0 axis
• Force bar clipped axis
• Color by expression legend
• Combo line labels off
• Gantt table
• Dynamic classes
• Unicode symbols
• Hide fields
• KPI cards revisited
• Sankey as decomposition chart
• Image to map revisited

I want to emphasize that many of the tips were discovered by others than me, I tried to credit the original author at all places when possible.

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

• 24 days of visualization Season III, II, I
• Top 10 Tips Part VIII, VII, VI, V, IV, III, II , I 
• Let's make new charts with Qlik Sense
• FT Visual Vocabulary Qlik Sense version
• Similar but for Qlik GeoAnalytics : Part III,  II, I

Thanks,
Patric

Qlik NPrinting Excel reports fail when a level is inside hidden columns. The following error is shown:

Object reference not set to an instance of an object

The error message occurs when the columns where a level is placed are hidden.

Resolution

Upgrade to NPrinting February 2024 IR (24.4.5) or later versions.

Cause 

OP-95820, resolved in Qlik NPrinting February 2024 IR (24.4.5) or later versions.

Internal Investigation ID

OP-95820

Environment

Qlik NPrinting May 2023

A specific line chart responds slower than expected and consumes excessive browser memory. 

Resolution

This is working as expected.

Set Presentation > Missing values to Show as gaps

Cause

The affected chart has the Presentation > Missing values set to Show as Zero.

This will fill missing values with zeros and render all line segments, leading to a slow response time. With Missing values set to Show as gaps, all line segments involving missing values will be skipped, improving performance. 

Internal Investigation ID(s)

QB-30492

Environment

• Qlik Sense Enterprise on Windows

Exporting charts from QlikView .qvw documents and downloading the files may lead to charts with corrupted visuals. This may specifically impact complex charts (utilizing shadows, scales, and other visual settings).

Example One:

This bar chart with active shadows has been downloaded to PDF. The file is corrupted and fails to open with the error Failed to load PDF document. 

Example Two:

Gauge charts scale exported bigger and the charts get smaller.

Resolution

Add the configuration SlowPrinting in the QlikView Settings.ini and export again.

Example for QlikView Desktop:

1. Close Qlikview Desktop
2. Navigate to C:\Users\<User>\AppData\Roaming\QlikTech\QlikView\
3. Open Settings.ini as an administrator
4. Add the following parameter under [Settings 7]
   SlowPrinting=1 (IMPORTANT: The line must be added at the top of the list i.e directly under [Settings 7])
5. Save the file.

Printing will be slower and potentially generate larger files.

For information about editing the settings.ini file, see How to change the settings.ini in QlikView Desktop and QlikView Internet Explorer Plugin.

Cause

By default, QlikView is set for high-speed PDF printing which may result in perceived lower-quality PDFs.

In turn, if it is not set for "high speed" PDF printing, and apparent lower quality is experienced, this may be a user perception issue and actually due to the "low speed" setting being enabled.

Environment

• QlikView

The file name format of charts downloaded from a QlikView app hosted on Qlik Cloud Analytics has changed with January 2025. Previously, file names were fixed, such as Chart_excel. The file now is a unique GUID for each download.

This is working as designed. The behavior is consistent with the client-managed version of the QlikView access point. 

Qlik Sense apps were not affected by this change.

Environment

• QlikView
• Qlik Cloud Analytics

You can access Qlik Sense demo apps from https://demos.qlik.com/.

If you are looking for real-life business examples, our Qlik Gallery hosts a platform meant for sharing apps, outcomes, and ideas. It is not restricted to Qlik-provided demos and mostly consists of customer examples.

If you are looking to download demo apps:

1. Go to https://demos.qlik.com/ 
2. Select Downloadable from the available Tags
   
3. Open the App
4. A Download button will be available (if logged in)
   
   

Exporting a chart to PDF may lead to an exported file size of 0 or 1KB. The resulting file fails to open:

Failed to load PDF document

The file on disk is corrupted.

Resolution

The chart background style Shadow (Plot Area Background Style) has limitations when printing to PDF. 

Two workarounds exist.

Workaround One, disable the Background Style:

1. Right-click the chart
2. Open Chart Properties
3. Go to the Style tab
4. Review the Plot Area Background Style
5. Switch it away from Shadow
   
   
   
6. Apply the changes

Workaround Two, configure ShowPrinting:

1. Open Settings.ini for Qlikview Desktop 
   Typically stored in: C:\Users\USERNAME\AppData\Roaming\QlikTech\QlikView 
2. Below the [Settings 7] section, add the following parameter:

   [Settings 7] 
   SlowPrinting=1

Cause

The chart background style Shadow (Plot Area Background Style) has limitations when printing to PDF.

Internal Investigation ID(s)

QV-25445

Environment

• QlikView Desktop

1. Cannot export an entire table to .pdf 
2. Export Data does not equal Export as image, Export as pdf, and Export as ppt (only for stories). Export data is not managed by Sense Printing but done by the Qlik Sense Engine. 
3. Export Data allows the export of single visualization, not the entire sheet.
4. Export Data export an entire table, not only the selections. 
5. Export as image/pdf takes a snapshot of each object to be exported (the amount of data exported is the one visible at that moment), renders each visualization in the backend leveraging CEF (Chrome Embedded Framework) and then take a screenshot of the chart
6. Export as image/pdf doesn't necessarily reflect what is seen on screen. That means that is not what you see is what you get. The final result is affected by different things like current device (size, resolution,....), final format (A4, A3, letter, etc..), orientation (portrait/landscape), other settings (fit to page/keep current size), the browser you are using, etc....
7. Export as image/pdf may fail or generate blank results if a custom theme is in use. Padding, box-shadow and margin elements inside a theme can cause this problem.

Advanced options is not visible when editing a sheet. This can happen on a specific app even if the option was present before.

Resolution

You can activate the "Show Sheet Header" option in the app settings to make the "Advanced option" button visible again.

1. Open the App settings.
   
2. Activate "Show Sheet Header".
   

Cause 

For some reasons, the "Show Sheet Header" could be deactivated in an app. "Advanced Options" is invisible when this happens, because it is located in the sheet header that is removed. The app looks like this in editing mode:

Environment

• Qlik Cloud

When performing an Export of a Native Map in Qlik Sense only the points are being shown and not the actual background.

Current export result (Satellite background image is missing):

Or the map is entirely blank:

Environment

• Qlik Sense Enterprise on Windows 

Resolution

The port 443 to  imagery provider services.arcgisonline.com is probably blocked
Check and open port 443  (scroll down to "Web browser ports" and check "map").

Changing the background color of the button object to none results in the button displaying with the default background color (#006580). This is a known limitation as of today.

Resolution

Qlik is reviewing QB-29806 for future improvements. 

Workaround

To achieve transparency (mimicking none as the background color):

1. In the button's background option, choose "By Expression"
2. Fill in the expression as follows:

   ARGB(0,0,0,0)

   

Cause

This feature predates the introduction of transparency in the colorpicker, meaning it was designed to revert to the default color when none is chosen. 

Internal Investigation ID(s)

QB-29806

Environment

• Qlik Sense Enterprise on Windows August 2023 and higher
• Qlik Cloud

It is finally here: The first public iteration of the Log Analysis app. Built with love by Customer First and Support.

"With great power comes great responsibility." 

Before you get started, a few notes from the author(s):

• It is a work in progress. Since it is primarily used by Support Engineers and other technical staff, usability is not the first priority. Don't judge. 
• It is not a Monitoring app. It will scan through every single log file that matches the script criteria and this may be very intensive in a production scenario. The process may also take several hours, depending on how much historical data you load in. Make sure you have enough RAM 🙂
• Not optimised, still very powerful. Feel free to make it faster for your usecase. 
• Do not trust chart labels; look at the math/expression if unsure. Most of the chart titles make sense, but some of them won't. This will improve in the future. 
• MOD IT! If it doesn't do something you need, build it, then tell us about it! We can add it in. 
• Send us your feedback/scenarios!

Chapters:

•  01:23 - Log Collector

• 02:28 - Qlik Sense Services

• 04:17 - How to load data into the app

• 05:42 - Troubleshooting poor response times

• 08:03 - Repository Service Log Level

• 08:35 - Transactions sheet

• 12:44 - Troubleshooting Engine crashes

• 14:00 - Engine Log Level

• 14:47 - QIX Performance sheets

• 17:50 - General Log Investigation

• 20:28 - Where to download the app

• 20:58 - Q&A: Can you see a log message timeline?

• 21:38 - Q&A: Is this app supported?

• 21:51 - Q&A: What apps are there for Cloud?

• 22:25 - Q&A: Are logs collected from all nodes?

• 22:45 - Q&A: Where is the latest version?

• 23:12 - Q&A: Are there NPrinting templates?

• 23:40 - Q&A: Where to download Qlik Sense Desktop?

• 24:20 - Q&A: Are log from Archived folder collected?

• 25:53 - Q&A: User app activity logging?

• 26:07 - Q&A: How to lower log file size?

• 26:42 - Q&A: How does the QRS communicate?

• 28:14 - Q&A: Can this identify a problem chart?

• 28:52 - Q&A: Will this app be in-product?

• 29:28 - Q&A: Do you have to use Desktop?

Environment

Qlik Sense Enterprise on Windows (all modern versions post-Nov 2019)

How to use the app:

1. Go to the QMC and download a LogCollector archive or grab one with the LogCollector tool
2. Unzip the archive in a location visible to your user profile
3. Download the attached QVF file
4. Import/open it in Qlik Sense 
5. Go to "Data Load Editor" and edit the existing "Logs" folder connection, and point to the extracted Log Collector archive path
   1. If you are using a Qlik Sense server, remember to change the Data Connection name back to default "Logs". Editing via Hub will add your username to the data connection when saved.
6. Go to the "Initialize" script section and configure:
   1. Your desired date range or days to load
   2. Whether you want the data stored in a QVD
   3. Which Service logs to load (Repository, Engine, Proxy and Scheduler services are built-in right now, adding other Qlik Sense Enterprise services may cause data load errors).
7. LOAD the data!

My workflow:

1. I'm looking for a specific point in time where a problem was registered
2. I use the time-based bar charts to find problem areas, get a general sense of workload over time
3. I use the same time-based charts to narrow in on the problem timestamp
4. Use the different dimensions to zoom in and out of time periods, down to a per-call granularity
5. Log Details sheets to inspect activity between services and filter until the failure/error is captured
6. Create and customise new charts to reveal interesting data points 
7. Bookmarks for everything!

Notable Sheets & requirements:

• Anything "Thread"-related for analysing Repository Service API call performance, which touches all aspects of the user and governance experience
  • Requirement: Repository Trace Performance logs in DEBUG level. Otherwise, some objects may be empty or broken.
• Commands: great for visualizing Repository operations and trends between objects, users, and requests
• Transactions: Repository Service API call performance analysis. 
  • Requirement: Repository Trace Performance logs in DEBUG level. Otherwise, some objects may be empty or broken.
• Task Transactions: very powerful task scheduling analysis with time-based filters for exclusion. 
• Log Details sheets: excellent filtering and searching through massive amounts of logs.
• Repo + Engine data: resource consumption and Thread charts for Repository and Engine services, great for correlating workloads.  

*It is best used in an isolated environment or via Qlik Sense Desktop. It can be very RAM and CPU intensive.

The information in this article is provided as-is and to be used at own discretion. Depending on tool(s) used, customization(s), and/or other factors ongoing support on the solution below may not be provided by Qlik Support.

Related Content 

Optimizing Performance for Qlik Sense Enterprise - Qlik Community - 1858594

Dragging and dropping the Qlik Map object onto a sheet results in the following error:

The visualization was not found on the server. This extension is not available: map ()

Inspecting the error in the browser developer tools (Developer tool console logs) shows the following error:

geo.error.WebmapInvalidkey

Invalid key

Resolution

Match the serverKey between Qlik Sense Enterprise on Windows and Qlik GeoAnalytics.

1. View the key in GeoAnalytics:
   1. Open the GeoAnalytics Server Administration console
   2. Go to Access Module
   3. Open Users and Keys 
   4. The key is listed in the By Service tab in access:multi:MAPCHART
      
      Expand the service user to reveal it.
      
      
      
      
2. Review and correct the key in Qlik Sense:
   1. Navigate to C:\Program Files\Qlik\Sense\Client\assets\
   2. Open mapconf.json
   3. Review the value for serverKey: 
   4. Match the value to that of the GeoAnalytics Server
      
      
      
      

      The serverKey value must not be surrounded by quotes (" ").

      Optional: If a custom URL is used in the mapconf.json file, match the serverURL value to the custom URL in use. 
      
      
   5. Save the file

Cause

Qlik Sense Upgrade or Migration. Every time Qlik Sense is upgraded or migrated, the "mapconf.json" file will be overwritten and needs to be updated again.

Related Content

Native mapchart settings 

Environment

Qlik Sense Enterprise on Windows 
Qlik GeoAnalytics 

Table header texts are not wrapped automatically when using the straight table from the custom objects. This is a known limitation.

Resolution

Usage pagination to work around the limitation.

1. Switch to Edit sheet mode
2. Select the Straight table
3. Enable Properties
4. Expand Presentation and scroll to Styling 
5. Toggle on Usage pagination by ticking the checkbox
   
   

Fix Version:

The limitation is on the roadmap for review. No date is currently set. 

Internal Investigation ID(s):

QB-21283

Environment

Qlik Cloud 

After upgrading to Qlik Sense Enterprise on Windows May 2024 or newer, exporting a sheet or visualization to a PDF leads to a blank PDF output. The same export worked as expected before the upgrade. 

This affects deployments running Windows 2012 R2, a version of Windows no longer supported by Qlik Sense Enterprise on Windows. It is incompatible with the current reporting_web_renderer.exe resource used by the Printing service.

Environment

• Qlik Sense Enterprise on Windows May 2024 and newer
• Windows 2012 R2

Resolution

Upgrade the server to a supported operation system and test again.

Cause

Microsoft dropped support for Windows 2012 R2 in January of 2023. The last version of Qlik Sense Enterprise on Windows which supported Windows 2012 R2 was Qlik Sense May 2023.

Related Content

Qlik Sense System Requirements 

Expect font not appearing in NPrinting Pixel Perfect PDF reports.

Environment:

Qlik NPrinting 

By Default, there are two fonts that can be selected in Pixel Perfect reports that will show the Chinese Characters,

1. Arial Unicode MS 
2. MS Gothic.

Most of the other languages will not show the characters.

In the Pixel Perfect Editor, simply switch to MS Gothic font

Chinese, Japanese ,German, Spanish, Portuguese languages will now appear in the PDF format report export.

Filter Panes and List Boxes in a Qlik App can be configured as a Radio Button menu, allowing only one value to be selected.

1. Begin editing the sheet with your Filter Pane; click Edit Sheet
2. Select your Filter Pane, open the Data menu section and click the Field name
3. Expand the Presentation menu
4. Tick the Checkbox mode option
   
   
   
5. Open the Fields menu
6. Select the field you are using in your Filter Pane
7. Click the Gears, opening the Field Settings
   
   
   
   
8. Tick the Always one selected value checkbox
   
   
   
   
9. You now have a Radio Button menu!
   
   

Environment

• Qlik Cloud Analytics
• Qlik Sense Enterprise on Windows

Related Content

• Enabling checkbox mode (help.qlik.com)

The conclusions in this article were reached in collaboration with cjgorrin from the European Commission's Joint Research Centre Qlik Sense team.

With Qlik Sense's new feature, Chart-level scripts, Add prefix is used with LOAD to append values to the HC1 table, representing the hypercube computed by the Qlik associative engine.

Based on this documentation and using the attached CHART LEVEL SCRIPT_ADD RESIDENT Load.qvf,  we would expect the table to have 12 entries (6 original and 6 new)

Example: as the hypercube already has 6 entries, we would expect 6 new entries to be added when using Add prefix. 

ADD LOAD 
  MyDim1 as MyDim1, 
  MyDim2 as MyDim2, 
  MyMeasure1*100 as MyMeasure1, 
  MyMeasure2*1000 as MyMeasure2 
RESIDENT HC1

The result only shows 6 rows, with only one of them being modified:

Resolution

This is working as designed. 

ADD LOAD RESIDENT will try to merge duplicate rows and the test cases expect this behavior. 

Workaround

To workaround this specific user case, add a blank space to one of the dimensions, as shown below:

ADD LOAD 
 MyDim1&' ' as MyDim1, 
 MyDim2 as MyDim2, 
 MyMeasure1*100 as MyMeasure1, 
 MyMeasure2*1000 as MyMeasure2 
RESIDENT HC1;"

Internal Investigation ID(s):

QB-27903

Environment

• Qlik Sense May 2024 and above
• Qlik Sense Cloud