Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
The feature allowing the Date format to be changed from the Data Manager is inaccessible from the Qlik Sense Enterprise on Windows November 2024 IR release to the SR 10 release.
Upgrade to the latest version of Qlik Sense Enterprise on Windows.
If an upgrade is not possible, change the Date Format from the Data Load Editor.
Example:
Date(Date#(YearMonth, 'YYYYMM'), 'YYYY/MM') AS YearMonthFormatChanged
Qlik Sense Enterprise on Windows November 2024 SR 11 and higher.
Product Defect ID: SUPPORT-1846
A Managed Space member is not able to create new report tasks even with the correct space permissions set. The Create button is greyed out and cannot be clicked. The minimal managed space permissions are set:
Ensure you do not have any 3rd party extensions running in the browser, such as AdBlock or similar. Disable or remove them and verify the Create Report button is once again available.
Adblock has been found to negatively interact with the Qlik Reporting create task button and other Qlik Reporting browser elements by aggressively blocking them.
An outer set expression returns an empty selection.
Examples:
Table 1 has source data that contains a row for Beta. The inner set and outer set behave identically.
Table 2 has source data that does not include a row for Beta. The inner set and outer set behave differently.
To make this work as expected, add “&” to the beginning of the set expression.
Example:
{&<group1={'Beta'}>} sum( {&<Company1={'A'}>} salary1)
This behavior is caused by how sets are combined when using multiple set expressions.
If the outer set expression produces an empty set, it is ignored when the inner set expression is evaluated.
The result is that only the inner set expression is used.
SUPPORT-3523
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:
This article explains how to avoid the "Failed to create search index" script error during reload.
A data load may fail with:
An error occurred
Internal engine error.
The script log will show:
2017-02-28 17:17:55 Creating search index
2017-02-28 17:17:55 Failed to create search index
2017-02-28 17:17:55 Execution finished.
The cause is currently unknown. Suspected to be an App corruption caused by external influences.
Insert "Set CreateSearchIndexOnReload=0" in the load script.
Even if this is disabled during the reload, the search index will be created later after the first search request of users.
Increase the timeout value.
Rather than disabling or removing the Search Index, you can attempt to increase the timeout before the reload will error out.
To do so, you will need to modify the Qlik Sense engine settings.ini and add a customized timeout value.
At QlikWorld 2020 I'm hosting 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:
* Charts *
Parliament diagram
Scatter with trackline
Calendar Graph - Month view
Calendar Graph - Year view
Meteogram
Spiral plot
Rank chart
Slope graph
Timeline chart
Candlestick chart
Range chart
Ridgeline chart
Stream Graph
Chord diagram
Coxcomb chart
Race chart
* UI tweaks
Toolbar toggle
Hide toolbar
Hide selection bar
Hide sheet title
Hide popup buttons
Hide Pivot buttons
Hide search bar
Hide three nav
Watermark
Center titles
Highlight rows
Larger scrollbars
* Dev tips*
Scatter overlap
Persistent colors
Color thresholds
Trellis container
Responsive and mobile tips
Include from Github
Tooltip table
Radial bar charts
100% bar charts
Title and text matters more than we think
Thumbnails
Quarterly month average
Image to chart
Magic quadrant
Link to app
I want to emphasize that many of the tips are invented 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
A Qlik application has been successfully reloaded in a tenant. The reload has stored additional tables in a QVD.
Reviewing the Dataset (QVD) in the Catalog does not show the correct number of rows after the reload. The information is not automatically updated.
The rows only update once the Compute button is clicked.
This is currently working as expected.
Qlik plans to provide scheduling capabilities for the Profile and Data Quality compute. No estimated release date or other details can yet be determined for this feature.
Profiling information is not automatically refreshed when QVD files change.
SUPPORT-2319
To create a sample document follow below steps. The steps can be applied to all editions of Qlik Sense, such as Qlik Sense Enterprise on Windows and Qlik Sense Business and SaaS.
Content:
Characters:
Load Chr(RecNo()+Ord('A')-1) as Alpha, RecNo() as Num autogenerate 26;
ASCII:
Load
if(RecNo()>=65 and RecNo()<=90,RecNo()-64) as Num,
Chr(RecNo()) as AsciiAlpha,
RecNo() as AsciiNum
autogenerate 255
Where (RecNo()>=32 and RecNo()<=126) or RecNo()>=160 ;
Transactions:
Load
TransLineID,
TransID,
mod(TransID,26)+1 as Num,
Pick(Ceil(3*Rand1),'A','B','C') as Dim1,
Pick(Ceil(6*Rand1),'a','b','c','d','e','f') as Dim2,
Pick(Ceil(3*Rand()),'X','Y','Z') as Dim3,
Round(1000*Rand()*Rand()*Rand1) as Expression1,
Round( 10*Rand()*Rand()*Rand1) as Expression2,
Round(Rand()*Rand1,0.00001) as Expression3;
Load
Rand() as Rand1,
IterNo() as TransLineID,
RecNo() as TransID
Autogenerate 1000
While Rand()<=0.5 or IterNo()=1;
Comment Field Dim1 With "This is a field comment";
NPrinting has a library of APIs that can be used to customize many native NPrinting functions outside the NPrinting Web Console.
An example of two of the more common capabilities available via NPrinting APIs are as follows
These and many other public NPrinting APIs can be found here: Qlik NPrinting API
In the Qlik Sense data load editor of your Qlik Sense app, two REST connections are required (These two REST Connectors must also be configured in the QlikView Desktop application>load where the API's are used. See Nprinting Rest API Connection through QlikView desktop)
Requirements of REST user account:
Creating REST "GET" connections
Note: Replace QlikServer3.domain.local with the name and port of your NPrinting Server
NOTE: replace domain\administrator with the domain and user name of your NPrinting service user account
Creating REST "POST" connections
Note: Replace QlikServer3.domain.local with the name and port of your NPrinting Server
NOTE: replace domain\administrator with the domain and user name of your NPrinting service user account
Ensure to enter the 'Name' Origin and 'Value' of the Qlik Sense (or QlikView) server address in your POST REST connection only.
Replace https://qlikserver1.domain.local with your Qlik sense (or QlikView) server address.
Ensure that the 'Origin' Qlik Sense or QlikView server is added as a 'Trusted Origin' on the NPrinting Server computer
NOTE: The information in this article is provided as-is and to be used at own discretion. NPrinting API usage requires developer expertise and usage therein is significant customization outside the turnkey NPrinting Web Console functionality. Depending on tool(s) used, customization(s), and/or other factors ongoing, support on the solution below may not be provided by Qlik Support.
Qlik provides a QlikView Converter tool to convert QlikView documents (QVW files) to Qlik Sense apps. The converter tool can be used in the Dev Hub in Qlik Sense Enterprise and Qlik Sense Desktop.
Using the tool on the Qlik Sense Dev Hub may successfully proceed by converting Dimensions, Measures, Visualizations, and Variables, but will then fail as soon as the Create app button is clicked:
Internal Server Error
The following error is shown in the QlikView converter tool:
Global ERROR UserId: User.Name4Server.com@USERDIR, Error: More than one user matching UserDirectory=USERDIRECTORY; UserId=User.Namel%Server.com
The QlikView converter tool is provided as it is.
It is possible that some specific server configurations are not fully compatible with this tool. In some cases, user directories are not read correctly and may require the encoding system to be changed from ascii to utf8.
If this does not work, it is possible to use the same functionality provided by Qlik Sense Desktop.
Change the encoding system:
const base64EncodedHost = FileSystem.readFileSync("C:\\ProgramData\\Qlik\\Sense\\Host.cfg", "ascii");to
const base64EncodedHost = FileSystem.readFileSync("C:\\ProgramData\\Qlik\\Sense\\Host.cfg", "utf8");
Use Qlik Sense Desktop
A Binary Load on a Qlik Sense App located in the Qlik Sense App share fails.
The following error is logged in the Script Log:
Qlik Sense Enterprise on Windows
QlikView
There are four main requirements for a successful binary load:
*Binary Loads from live Qlik Sense Apps are not supported in Qlik Sense Enterprise on Windows.
Example: BINARY [SenseAppID]; (for example BINARY 2d405d18-ddd3-5353-5128-adce12e482bd;)
QVF files in the Server Apps folder are read/written by Engine service when:
During these operations, those files may be locked and causing reload task failure.
For Qlik Sense:
Do binary load on static QVF/QVW files if necessary, or load QVD files generated by other QVD generators.
What to generally consider:
Storing a table containing NULL value to a txt or qvd file fails with error General Script Error in statement handling
For example, the following piece of the script fails with the above error when executed:
DataTable:
LOAD * INLINE [
NP
1
];
LEFT JOIN
LOAD * INLINE [
NP, AD
2, test
];
STORE AD FROM DataTable INTO [lib://Temp/test.csv] (txt);
If you experience the issue in an up to date Sense environment, connect with our active Qlik Community for creative application development assistance and ideas.
QlikView QVD files contain lineage information of the stored data.
QlikView any version
The lineage information can be found in the QVD file XML header and might look like below, with connection details and the SQL statements used during reload.
QlikView and Qlik Sense load either missing or additional zeros, compared to the values in the data source.
For example data like in the below script is loaded with incorrect leading zeros.
LOAD * Inline [
F1, F2
1, a
01, b
02, c
2, d
];
On the second row the leading zero is missing, and on the fourth row, there is an unexpected additional leading zero.
QlikView
Qlik Sense Enterprise on Windows
Qlik Cloud
The observed behaviour is a part of fundamental Qlik engine functionality and data compression technique.
In short, this means that Qlik interprets and associates loaded data by best effort. As part of Qlik optimization and compression technique the same reoccurring value in a field is stored on the first occurrence only, and the following occurrence reference to the first (stored) value. This means that two values with identical numerical representation can not be stored with two different textual presentations in the same field in Qlik.
Please keep in mind that all numerical values in Qlik act as dual values. This means that they have an underlying numerical value that is used for calculations, and a textual formatted value which is the value seen in charts or as calculations results.
In the example below four rows of data are loaded. In the field F1 there are four different value.
LOAD * Inline [
F1, F2
1, a
01, b
02, c
2, d
];
Identical numerical values are associated with the same textual presentation value in Qlik . For this reason, it is not possible to store the same numerical value with different textual presentation values.
One way to resolve this is to format the values as text by using Text() during reload.
LOAD
text(F1) as F1,
F2
Inline [
F1, F2
1, a
01, b
02, c
2, d
];
This will result in the visual values looking identical to the data source.
NOTE: Value formatted with Text() will not have underlying numerical values, hence calculations on these values is not possible.
Scheduled tasks will fail in Qlik Sense, if the App contains Section Access while could be working fine from the script editor.
Investigating the log file <Servername>_System_Engine.txt shows a warning message similar to:
WARN domain System.Engine.Engine 89 6ac41964-2910-4a17-9162-c40119b2d3d6 domain\qliksense System: DetermineAccess: Failed to access the following document af18ffcb-6b60-4546-9fa5-f385172eebec with the user: 0 sa_scheduler 20181126T181325.903+0100 6864 7120 eaa1c5c2-1850-40cb-a490-0e6158df82b0 af18ffcb-6b60-4546-9fa5-f385172eebec 20181126T181055.000+0100 6ac41964-2910-4a17-9162-c40119b2d3d6
On the script log you will see:
Execution Failed
Execution finished.
Qlik Sense Enterprise on Windows governs access to resources (such as Apps) through the Repository Service. An account for each service is created in the PostgreSQL database during setup, such as the sa_scheduler account above. For the Scheduler to be able to access the App during reload, this account must be added into Section Access, not the account running the actual service.
See also the help documentation:
"The INTERNAL\SA_SCHEDULER account user is required to enable reload of the script in a Qlik Management Console task." Managing security with section access
The following requirements must be met:
Section Access; LOAD * INLINE [ ACCESS, USERID ADMIN, INTERNAL\SA_SCHEDULER ];
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.
Support has collected a number of resources helpful for the implementation of Qlik Sense Version Control functionality.
Qlik Partner Solutions:
Saving an edited task in Qlik Cloud may lead to the error:
Unable to save task
Analyzing the issue with the browser's developer tools, we see that the error 500 Internal Server Error is returned. For tips on how to use developer tools, see Save network web traffic (HAR/XML file) and console logs from the browser's developer tools.
To resolve the issue, we remove the connection to the corrupt cron job, then set the task to its correct schedule:
There was a problem with the task's cron job in Qlik Cloud.
In Qlik Sense, when there is a commented out portion of the script, if "//" is deleted and the script is saved, all the text will turn black and all syntax highlighting will be lost. If pages of the script are toggled between, a message that says "we have disabled syntax highlight to maintain performance" appears and the highlighting will come back but if previous steps are followed again,commenting will also be disabled again.
This is working as designed.
It is the current solution for dealing with deeply nested if statements. In many cases these deeply nested if blocks will cause real performance issues (crashing the browser). The best practice is to not use nested ifs when possible. The commenting/uncommenting works because we count the levels. Pretty sure 10 levels deep we trigger the perf warning. So if they comment out one and it's only 9 it won't complain.
The Sense System Performance Analyzer app has been deprecated.
The Sense System Performance Analyzer (Sense System Performance Analyzer) does not show data. The reload of the app has finished successfully.
This is expected. The app pulls platform and process performance data as well as Windows event data from the logging database. However, since the May 21 release centralized logging has been deprecated. See Deprecation of Centralized Logging in Qlik Sense Enterprise on Windows.
HLP-10692