Skip to main content
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Why does my Pivot table’s Subtotal NOT giving correct summation?

Dear Qlik experts,

I’ve this pivot table with row level tow (2) fields; Week and Products. I want to allow users to filet by Products and if no filter used for the product want to show all the products with the sub-total on week level.

Qlik TotalQlik Total

It's giving me subtotal 71 than 917.


Thank you very much for your help and effort.

Labels (1)
2 Replies
Specialist II
Specialist II

Please check if you are really using the sum() function in that Expression.
Seems like you are currently using Count() there.

If your expression written with If..Else condition definitely it won't give proper one. But, Simply use like

Sum(Aggr(Your expression, Your Dimension1, Your Dimension2. ...))

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful