Images included in an Excel worksheet may appear stretched or use the wrong aspect ratio when previewed in an Excel report or after being distributed in an on-demand reporting task.

This affects charts imported by Qlik Sense as well as static images and shapes. 

Resolution

To fix the affected Qlik Reporting template, change the body font currently used in the Excel template to a supported font family:

1. Create a new Excel workbook or open an existing Excel template using Office Web or Excel
   Desktop
2. For each Excel worksheet contained in the Workbook, click on the worksheet’s top left
   corned or press Ctrl-A to select all the cells.
3. In the Excel ribbon bar, under the Home menu, choose a supported body font
   
   Supported fonts:
   
   
   • Andale Mono
   • Arial (Bold, Italic, Bold Italic)
   • Arial Black
   • Calibri (Bold, Italic, Bold Italic)
   • Calibri Light (Italic)
   • Cambria (Bold, Italic, Bold Italic)
   • Candara (Bold, Italic, Bold Italic)
   • Comic Sans MS (Bold)
   • Consolas (Bold, Italic, Bold Italic)
   • Constantia (Bold, Italic, Bold Italic)
   • Corbel (Bold, Italic, Bold Italic)
   • Courier New (Bold, Italic, Bold Italic)
   • Georgia (Bold, Italic, Bold Italic)
   • Impact
   • Times New Roman (Bold, Italic, Bold Italic)
   • Trebuchet (Bold, Italic, Bold Italic)
   • Verdana (Bold, Italic, Bold Italic)
   • Webdings
   • WenQuanYi Zen Hei
     
     More fonts could be supported in the future.
     
     
4. After changing your font, double-check the size of images added to the template (both static
   images and dynamic Qlik Sense charts). Font modification may have altered the image; if necessary, resize or re-add the image.

To prevent other related symptoms, set the main display zoom level to 100% when creating and editing an Excel template on the Windows platform. Note that this is a Windows OS setting and not the Zoom set within the Excel App.

Cause

An unsupported font is used in the current Qlik Reporting template. 

Internal Investigation ID(s)

SUPPORT-3842, QCB-32146

Environment

• Qlik Cloud Analytics
• Qlik Reporting

The value of a reference line for a scatter plot chart may be beyond the displayed range and out of view. In this case, hovering over the icon indicating the reference line will not show its label tooltip.

The issue persists even if Show Label is checked.

Waterfall charts are also affected. 

No tooltip in scatter plot

tooltip works in other charts

Resolution

This behavior is being investigated as a defect (SUPPORT-3799). The expected fix release is the Qlik Sense Enterprise on Windows November 2025 release.

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 SUPPORT-3799 for reference.

Fix Version:

Qlik Sense Enterprise on Windows November 2025

Cause

Product Defect ID: SUPPORT-3799

Environment

• Qlik Sense Enterprise on Windows May 2024 to May 2025 
• Qlik Sense Desktop May 2024 to May 2025 
• Scatterplot charts and Waterfall charts

The QlikView Multi-box object does not show all expected results when opening from the QlikView AccessPoint.

Example:

Searching for *abc returns four results, while there are five matches in the data.

This may occur after an upgrade (such as upgrading QlikView from an earlier release to 12.90).

Resolution

Review your browser's extensions. A known root cause for this issue is a custom browser extension that modifies a page's CSS (Cascading Style Sheet). This resulted in the results being hidden by the search box.

To resolve this, disable or otherwise modify the custom extension. 

Internal Investigation ID(s)

SUPPORT-722

Environment

• QlikView

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)
   
   

In Qlik Sense, bookmarks can be created with the "Include Layout State" option to capture both current selections and the layout of visual objects, such as the expanded or collapsed state of pivot tables. However, users may notice that after reloading the document and reapplying the bookmark, the pivot table does not return to the expected expanded/collapsed layout.

Resolution

To ensure that the pivot table layout is retained when using bookmarks:

• Avoid changing the structure of the pivot table after creating the bookmark.
• Ensure that dimension value order remains consistent in the data source to prevent layout mismatch.
• If changes to dimension order or pivot structure are necessary, consider creating new bookmarks to reflect the updated layout.

Cause

This behavior is due to how Qlik Sense manages the expand/collapse structure in pivot tables. Specifically:

• Qlik Sense relies on the data load order of dimension values to track and restore the expand/collapse state.
• If the order of values in a dimension changes in the source data, the original layout state stored in the bookmark becomes invalid.
• When the pivot table structure changes (e.g., dimensions are reordered, added, or removed), Qlik Sense considers it a new layout, and the previously saved layout state can no longer be applied.

Impact of Changing Dimensions in a Pivot Table

If you change the pivot table structure after creating a bookmark (such as removing or reordering dimensions):

• Qlik Sense treats this as a different visual object layout.
• The bookmark will still apply filter selections but not the layout state.
• The expand/collapse configuration of the pivot will not be restored.

Environment

• Qlik Sense Enterprise on Windows all versions
• Qlik Cloud Analytics

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

It is possible to add a Table of Contents (TOC) to Qlik NPrinting reports using the standard Microsoft Word functionality.

The font in the TOC depends on two factors:

• The font of the different sequences' names depends on the font of the corresponding header
• The font used for the dots and the page numbers depends on the font of the body

This means that in the same line of a TOC, two fonts may be present. One corresponds to the chapter or paragraph name (header), while the other corresponds to the dots and the page number.

The best way to manage this correctly is to create a theme defining the different fonts and to apply it to the Microsoft Word template:

1. In Microsoft Word, open the Design tab 
2. Click Fonts
3. Choose Customized Fonts...
   
   
   
   
4. Choose the Heading and Body font
5. Save the template
   
   
   
   
6. Select the content you want the template to apply to 
7. Apply the template you created
   
   

Environment

• Qlik NPrinting

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 IX, 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

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.

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