Skip to main content

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Qlik Cloud Maintenance is scheduled between March 27-30. Visit Qlik Cloud Status page for more details.
Showing results for 
Search instead for 
Did you mean: 

qlik sense pivot table wrong behaviour of sums



in Qlik Sense I'm would like to compare my order book and planning on a customer, material and date level.

For my statement if(sum(#plan)>sum(#orders),sum(#plan),sum(#orders) the pivot table seems to calculate this for every dimension seperately. That leads to a behaviour where the sum above my material on the customer level is wrong because it compares the sum of sales (customer level) with the sum of plan (customer level) and does not add the sums of the materials one level deeper. So if i am now manually adding up the numbers on material level on the calculator the sum is wrong whereas it shows the exact sum of the sales on customer level (depending whats higher).


Table plan is concatenated to table orders.

I would really like to avoid joining those tables and compare on a script level in my data model. 

Are there any solutions to this?

Labels (1)
1 Reply

after hours playing around with i found it out: