Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
nareshthavidishetty
Creator III
Creator III

Pivot table totals

Hi,

In Pivot table I'am facing an issue in total like when i split total in group wise it's more but the over all total is less.

Can anyone

4 Replies
vikasmahajan

attach some samples and examples , qvw so any one can give you solution !

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
Not applicable

Hi,

Have you check partial sum in presentation tab for all the dimension field.1.PNG

should get right answer then.

tyagishaila
Specialist
Specialist

Share sample data or screen shot, to clear what exactly happens wrong?

PrashantSangle

Hi,

What is your expression ???

Use Aggr() in your expression.

try like

sum(Aggr(YourExpression,your chart Dimension))

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂