Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Announcement: Certain actions are currently causing a Page Not Found error. This is a known issue and we are working with the platform vendor to investigate and resolve it.
Highlighted
mja_jami
New 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 Total.PNGQlik Total

It's giving me subtotal 71 than 917.

Excel total.PNGExcel

Thank you very much for your help and effort.

Tags (2)
Labels (2)
2 Replies
zhadrakas
Valued Contributor

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

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

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

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. ...))

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)