Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I add a table (qvd with 38000 records) to my data model and if I load the table as a stand alone table I get all 38000 records but if I add a key field to connect to the rest of the data model I only get 350 records. Never seen this behaviour before. Why is this happening and what can be done?
Hi community,
I'm developing an application in Qlik Cloud and added a new Filter Pane based on a field created in the load script. In the Dev Space environment, the filter works perfectly and displays the values correctly.
However, after publishing the application to the Managed Space using the 'Publish to Space' (replace) option, the filter appears empty for users.
The field used in the filter is derived from a transformation in the load script, where I extract only the numbers after the hyphen from a field like 'ABCDEF_GH-12345'.
Has anyone experienced this? What could cause a filter to appear empty in the published app even though it works correctly in the Dev Space?
Thank you!
Could anyone please provide any guidance on creating a Salesforce connection in QDI?
Thanks,
Jeff
Hi Community,
We previously unbundled PostgreSQL from our Qlik Sense environment and upgraded to the May 2024 version, as our earlier setup was outdated. Now that May 2024 has reached end of life, we’re planning the next Qlik Sense upgrade. This also means we need to update PostgreSQL again, especially since it contains VA points and relies on older libraries.
I have two main questions:
Thanks in advance for your help!
Hello Team,
I am currently working on the Qlik Data Analytics Pre-Sales Certification training and have successfully completed 2 out of the 3 sections in the course.
While following the instructions provided in the certification exercise, I am encountering an error in 2 sheets of the application. The error displayed is:
“Operation was rejected because the system is not in a state required for the operation’s execution.”
Because of this issue, I am unable to proceed further with the hands-on activity.
Certification Portal:
Qlik Data Analytics Pre-Sales Certification
Additional Details:
Requesting your support in identifying the cause and helping resolve the issue so I can continue the certification exercise.
Thank you.
Regards,
Reshna Nandipi
Hi everyone,
We have a webinar coming up and wanted to share it here. If you are working with AI in Qlik, this one is worth checking out. It's not too late to sign up, and a recording will be available for registrants afterward.
WEBINAR: From Vibe Coding to Control: Increase the Value of AI Across the Qlik Lifecycle
DATE: May 14, 2026
TIME: 10:00 - 11:00 AM CDT
What you'll learn:
👉 From Vibe Coding to Control Registration Link
QSSTAnalyzer.zip
This package contains a Qlik Sense app, which can be used for analyzing Qlik Sense performance test results generated by the Qlik Sense Scalability Tools and the Qlik Sense Enterprise Scalability Tools.
Included parts:
SCResultAnalyzer.zip
This package (referred to as SC Results Analyzer) contains a set of QlikView documents, which can be used for analyzing both QlikView and Qlik Sense performance test results generated by the Qlik Sense Scalability Tools and the QV Scalability Tools.
Included parts:
------------------------------------------------------------------------------------------------------------------------------------------
Update 2021-01-04:
Update 2020-12-18:
Update 2019-11-14:
Update 2019-10-31:
Update 2019-10-14:
Update 2019-05-17:
Update 2017-09-26:
Update 2017-03-17:
Your use of Scalability Tools will be subject to the same license agreement between you and Qlik. Qlik does not provide maintenance or support services for the SC Result Analyzer and QSSTAnalyzer, however please check Qlik community for additional information on its use.
Hi Friends,
We have recently lost our remote server where we had Qliksense Enterprise installed. Server is not Turning ON due to Hardware/Disk failure. Server was not a VM and we dont have uptodate backups for our Qliksense apps/data/repository.
We are looking for recovery options but not sure whether we will be able to recover everything.
If we are able to recover, What should be our next steps to get our Qliksense working again on a new VM?
Can someone please share step by step process to restore Qliksense in a new machine.
Hello All,
I am looking for Pivot - multi row Expression solution:
Attached is the Excel picture which is my requirement.
I have achieved the arrangement as is: look at the Pivot created in the Qlik Sense (Enterprise / Windows)
Code used:
Script Editor :
VC_Metric_Header:
LOAD * INLINE [
R1_Header, R2_Header, SortOrder
Actual Net Sell-In Revenue, Revenue, 1
Actual Net Sell-In Revenue, GM, 2
Actual Net Sell-In Revenue, GM%, 3
Cross Border Adjustments, Revenue, 4
Cross Border Adjustments, GM, 5
Cross Border Adjustments, GM%, 6
Adjusted Net Sell-In Revenue, Revenue, 7
Adjusted Net Sell-In Revenue, GM, 8
Adjusted Net Sell-In Revenue, GM%, 9
Adjusted Net Sell-In Revenue, Weighted Revenue, 10
Strategic, Volume, 11
Revenue, Target, 12
Revenue, Achieved %, 13
GM, Target, 14
GM, Achieved %, 15
Strategic, Target, 16
Strategic, Achieved %, 17
];
UI Expression:
Pick(
Match(
ONLY(R1_Header & '|' & R2_Header),
'Actual Net Sell-In Revenue|Revenue',
'Actual Net Sell-In Revenue|GM',
'Actual Net Sell-In Revenue|GM%',
'Cross Border Adjustments|Revenue',
'Cross Border Adjustments|GM',
'Cross Border Adjustments|GM%'
),
Num($(vActNetSellInRev),'€ #,##0;-€ #,##0'),
Num($(vActNetSellInGM),'€ #,##0;-€ #,##0'),
3,
Num($(vPOSRev),'€ #,##0;-€ #,##0'),
Num($(vPOSGM),'€ #,##0;-€ #,##0'),
Num($(vPOSRev)/$(vPOSGM),'#,##0.00%')
)
The problem is 'vActNetSellInGM':
// Sell-In Adjusted Margin
Sum(
Aggr(
If(
Only(REASON_CODE) = 'Sales Order'
and
(
(
Sum({<LineType = {'ERP_Sales_In'}, EXCLUDED_SALE = {'N'}>} BASE_CURRENCY_VALUE)
-
(
Sum({<LineType = {'ERP_Sales_In'}, EXCLUDED_SALE = {'N'}>} LOGICAL_QUANTITY)
* Sum({<LineType = {'ERP_Sales_In'}, EXCLUDED_SALE = {'N'}>} SAP_AVG_INV_COST)
* ($(vVar%) / 100)
)
)
/
Sum({<LineType = {'ERP_Sales_In'}, EXCLUDED_SALE = {'N'}>} BASE_CURRENCY_VALUE)
) < 0.10,
Sum({<LineType = {'ERP_Sales_In'}, EXCLUDED_SALE = {'N'}>} BASE_CURRENCY_VALUE) * 0.10,
If(
Match(Only(REASON_CODE),
'PA CREDIT MEMO',
'Project Price Claim',
'REBATE',
'STOCK PROTECTIO',
'Target-Based Rebate',
'Manual Credit'
),
Sum({<LineType = {'ERP_Sales_In'}, EXCLUDED_SALE = {'N'}>} BASE_CURRENCY_VALUE),
(Sum({<LineType = {'ERP_Sales_In'}, EXCLUDED_SALE = {'N'}>} BASE_CURRENCY_VALUE)
-
(
Sum({<LineType = {'ERP_Sales_In'}, EXCLUDED_SALE = {'N'}>} LOGICAL_QUANTITY)
* Sum({<LineType = {'ERP_Sales_In'}, EXCLUDED_SALE = {'N'}>} SAP_AVG_INV_COST)
* ($(vVar%) / 100)
))
)
),
ERP_DeliveryRegion,
AdjustmentType,
INVOICE_SUB_TYPE,
REASON_CODE,
INVDATE,
INVOICE,
ITEM_ID
)
)
The header grouping is on REGION and REGION_GROUP, so AGGR() working in the Pivot table with R2 header whereas, the moment I introduce R1, its making it worse.
Can you please suggest how can I achieve this?
Business Formula:
If (Margin < 10%, Sum(BCV), Sum(BCV) * 10%,
For some REASON_Code, Sum(BCV), Sum(BCV) - VC Cost)
Aggr () them on the granular fields.
I will really appreciate any advice around this.
Dear Community,
I'm stuck on a problem I can't seem to solve.
Here is a table (see attachment).
I want to create a line chart. The dimension is the contract end date. Multiple contracts may have the same contract end date.
The measure is the total number of cars still under contract on the given date.
The desired result is in Column D. The explanation of the result is in Column E.
How should the measure be formulated to produce the desired result?
Thank you very much for your help!
Best regards
Introducing a new agentic experience in Qlik Answers and open AI access through MCP. Later this March: Discovery Agent and trusted data products embedded into analytics.
Yesterday’s innovations are today’s table stakes. BARC reveals modern ISVs’ most essential capabilities.
Your journey awaits! Join us by Logging in and let the adventure begin.
Data Restores Confidence: How SEFAZ-RS Used Qlik to Support the Rebuilding of a State.
AFIP revolutionizes management, optimizes resource allocation and strengthens data-driven culture
Global container shipping giant delivers data transparency to enable confident decision-making and operational efficiency.
Qlik turns raw data into valuable learning experiences, empowering both students and faculty at TTUHSC.
MillerKnoll partnered with Qlik Talend® data solutions to unify data across its diverse systems, accelerating critical processes and nearly eliminating data integration issues organization-wide.
Migration to Qlik Cloud Analytics optimizes analytics applications within months.
With Qlik Cloud Analytics, Rexel boosts performance by enabling self-service analysis, reducing prep time, and giving 3,000 users access to trusted insights.
Join one of our Location and Language groups. Find one that suits you today!
Únete a la conversación con usuarios de Qlik en todo México: comparte ideas, haz preguntas y conéctate en español.
Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。
Connectez-vous avec des utilisateurs francophones de Qlik pour collaborer, poser des questions et partager des idées.
Join data and AI leaders in Vienna on May 20, 2026 to learn how to scale AI into real enterprise impact.
Join the Nordics virtual event on May 20, 2026 to learn how to scale AI and unlock real enterprise value from anywhere.
Join data and AI leaders in Zurich on June 10, 2026 to learn how to scale AI and drive real enterprise impact.