Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Pivot Table Summation issue

Hi All,

I have one pivot table with count of values, in this i have used grouping and shown group total based on dimensions. In that the individual dimension values are coming correct but the group total summation values are coming wrong. Any ideas on why this happening? Any suggestions on how to resolve this?

2 Replies
PrashantSangle

Hi,

USe

Count(Aggr(Count(Values),Dimesion1,Dimesion2))

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 🙂
jonathandienst
Partner - Champion III
Partner - Champion III

I suggest that you post details of the pivot table dimensions, expressions and partial sums settings at the very least. Better still and for more accurate help, upload a sample qvw with the pivot table and a sample of your data.

And please don't cross post your request to more than one forum site.

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein