Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
sara12
Contributor
Contributor

pivot table SUM function

Good morning, I have problem with my pivot table, I want to have a total but when it finds the same values it does not sum me, how can I control the totals function in qliksense.
 
thanks for help 
 
sara12_0-1680525457037.png

 

Labels (2)
3 Replies
Or
MVP
MVP

In a pivot table, a subtotal or total will apply the same formula as the detailed measure, e.g. if your measure is sum(Sales), the total will also be sum(Sales). This cannot be modified directly, though you can use Dimensionality() to force a different formula for subtotals / totals if desired.

sara12
Contributor
Contributor
Author

Can you please give me an example of how to use this function  Dimensionality()  in my case.

thaks 

Or
MVP
MVP

Unfortunately not - you've included no details about your existing dimensions, measures, or data structure, just a screen capture of some numbers. I'd suggest checking the documentation for examples:

https://help.qlik.com/en-US/sense/February2023/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/Inter...