Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
It's giving me subtotal 71 than 917.
Thank you very much for your help and effort.
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. ...))