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!

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:

• Issue occurs in 2 sheets within the application
• Error is consistently reproducible
• Attached screenshot for reference
  
  

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: 

• How AI helps catch issues while development is still in motion
• How metadata and AI keep context around changes without digging for it
• Where AI surfaces patterns across apps, reloads, and support activity
• How to keep quality and governance tight without adding more processes

👉 From Vibe Coding to Control Registration Link

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