Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Search our knowledge base, curated by global Support, for answers ranging from account questions to troubleshooting error messages.
Filter Panes and List Boxes in a Qlik App can be configured as a Radio Button menu, allowing only one value to be selected.
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:
This is working as designed.
ADD LOAD RESIDENT will try to merge duplicate rows and the test cases expect this behavior.
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;"
QB-27903
The conclusions in this article were reached in collaboration with cjgorrin from the European Commission's Joint Research Centre Qlik Sense team.
Based on Qlik Sense online documentation, a PUT statement can be used to access columns, rows i.e. to set a numeric value to the hypercube.
However, using a Dimension name in a PUT statement, the following error is thrown:
Load statement could not find target column [MyDim1] in hypercube
This is working as designed.
Put statements are not allowed to manipulate dimensions. The Qlik Sense online help will be updated to reflect this.
QB-27904
The conclusions in this article were reached in collaboration with cjgorrin from the European Commission's Joint Research Centre Qlik Sense team.
Based on Qlik Sense online documentation, PUT statement can be used to set some numeric value to the hypercube
But in the following example (see attached CHART LEVEL SCRIPT_Put Dimension_silently fails.qvf), PUT statement seems to do nothing i.e. when used, no error is returned and expected changes are not displayed
Put #hc1.dimension.1(rr) = 'myvalue_' & rr; Put #hc1.dimension.2(rr) = rr * 100;
This is working as designed.
Put statements are not allowed to manipulate dimensions. The Qlik Sense online help will be updated to reflect this.
QB-27952
You can apply styling to customize the app based on your company standards. These styles are managed through custom themes.
To create your own custom theme, you’ll need to compile a compressed zip folder with three key components:
See Themes overview.
Once you’ve created the theme, you can upload it to your Qlik Cloud Management Console.
Making changes to a Qlikview document (.qvw) or Qlik Sense app (.qvf) will sometimes break already existing bookmarks. This is sometimes unavoidable and is a risk developers need to be mindful of when making changes to existing deployments.
Bookmark functionality can be affected by the following changes:
Making any of these changes can lead to bookmarks that only apply some of the intended selections, or even none at all.
A developer making changes to a document will need to keep these limitations in mind, and test any existing bookmarks, especially after using sensitive functions like "Always One Selected". If a bookmark is discovered to be broken, recreating it after the changes have been made is the best method to get back to a working state.
Downloading a sheet to PDF results in a blank PDF being exported.
This was a known defect in February 2024.
Qlik Sense Enterprise on Windows February 2024 Patch 7 or any later versions, including May 2024.
Product Defect ID: QB-26818
After a Qlik NPrinting upgrade, some cells are blocked out with black color.
Example:
This is a known Vizlib extension defect. Verify that a Vizlip extension is in use and contact Vizlib support for further support.
Uncheck Keep Source Formatting in the template editor.
QB-22744
At Qonnections 2019 I hosted a session called "273367 Qlik Sense Visualizations, best practice and top tricks". Here's the app I used with all tips including test data. Tip titles, more details in app:
* Chart and UI *
Butterfly chart
Gantt chart
Grid chart
Dynamic charts
Map image background
Previous/next in selection
Cyclic groups
Dividers
Date search filters
Dynamic bookmark
Select null
* Add ons *
Above and below
Color above average
Bell curves
Trendlines
Accumulation
Top 5 lines
Offset measures
* Table *
Custom report
Change null color
Sum with null
Subtotals and empty rows
Indentation
Indicators and symbols
Traffic lights
Pajama striping
Sparklines
Link to app
There is also video available: https://www.youtube.com/watch?v=fIOcb_JGNb4&t=3s
I want to emphasize that many of the tips are discovered by others than me, I tried to credit the original author at all places when possible. Many of the tips have been published before on the Qlik Community, the app below can be viewed as my current top picks.
If you liked it, here's more in the same style:
Thanks,
Patric
Advanced options is not visible when editing a sheet. This can happen on a specific app even if the option was present before.
You can activate the "Show Sheet Header" option in the app settings to make the "Advanced option" button visible again.
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:
At Qlik Connect in Orlando 2024 I hosted a session called "708769: What's New in Visualizations". Here's the slides and the app I used during the presentation.
Thanks,
Patric
The problem occurs working with NPrinting On-Demand on QlikView installed on an environment with IIS. The On-Demand button does not generate the report, but shows an HTML compilation error containing this message:
Error Message: </b>CS0104: 'X509SigningCredentials' is an ambiguous reference between 'System.IdentityModel.Tokens.X509SigningCredentials' and 'Microsoft.IdentityModel.Tokens.X509SigningCredentials'<br><br>
Upgrade to QlikVew 12.90 IR or higher version and NPrinting February 2024 SR 2 or higher versions.
Both the programs must run a version mentioned above.
The problem is due to a defect.
QV-25303
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:
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:
Thanks,
Patric
When adding an alternate measure or alternate dimension to Tree map, Box plot, Distribution plot, or Histogram chart types, the newly added measures or dimensions are only visible via the Exploration menu.
This is working as designed.
To apply an alternative dimension or measure to a Tree map, Box plot, Distribution plot, or Histogram chart object, it must be done via the Exploration menu. To access the Exploration menu, hover over the chart object (the middle icon), and then select the different dimensions or measures associated with the chart object.
Qlik Sense Enterprise on Windows
Qlik Sense Business
Qlik Cloud
QLIK-96555
When embedding a sheet in Single Configurator, the user notices a blank area on the top
This is working as designed and can't be changed. It is a limitation that the sheet tile cannot be exported. See Downloading a visualization.
Change the value in css file to reduce the padding size:
At QlikWorld 2023 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:
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:
Thanks,
Patric
NPrinting report is hanging on preview or in a publish task preventing the report from generating as expected. In many cases with 'Carded' Qlik Sense themes, we are seeing this problem.
This is also seen when the extended sheet feature is used
"error=task SENSE_JS_PAINT_COVER_POINTS_TIMEOUT"
There is currently a fix coming to resolve 'carded' custom themes however this fix is still under investigation.
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 QB-24997 for reference.
Possible workarounds for this are:
NOTE: Extended or Custom sheet sizes are not fully supported. See Qlik Help page below for details
Qlik Sense custom and extended sheets
A Qlik app may show an Incomplete Visualization or Invalid Visualization error. This article covers the most common root causes.
Incomplete Visualizations:
Invalid Visualizations:
The information in this article is provided as-is and will be used at your discretion. Depending on the tool(s) used, customization(s), and/or other factors, ongoing support on the solution below may not be provided by Qlik Support.
The Chart Exploration panel is not shown in straight tables after the upgrade to Qlik Sense May 2023 Patch 3. The option is still visible when you right click on the table, but it does not work: the table is just enlarged or an empty window appears instead of the Chart Exploration.
The problem is not present in any Qlik Sense releases previous to May 2023 Patch 3. It is fixed in Qlik Sense May 2023 Patch 6 and higher releases. The Qlik Sense August release was not affected.
In releases prior to May Patch 6, it is possible to resolve the problem on the affected releases by following these steps:
An incorrect formatting of the paths in the 'import-map.json' file causes the problem.
QB-20719, QB-21856