topic Totals in Pivot Table in QlikView

Totals in Pivot Table

psk180590 — Wed, 25 Nov 2020 16:16:04 GMT

Hello All,

I have recently encountered a problem with the Totals in my Pivot Table(Show Partial Sums).

Below is my Expression which calculates Sum(Quantity) for various Dimensions:

if(vBillNum=1, count({<Flag_Actionspaket={'1'}>} distinct %Key_Header),sum({<Flag_Actionspaket={'1'}>}Quantity)).

But, the Sum displayed in Pivot Table varies from Dimension to Dimension.

I have already learnt about using the Aggr function, but not sure how and where to implement in my case. Could some one throw some light into this topic.

TIA!!

Re: Totals in Pivot Table

stabben23 — Tue, 06 Feb 2018 09:18:09 GMT

If you start an Expression in pivot With if, then a total will not get calculated.

you need to wrap a sum around Your Expression and probably a aggr function.

sum(if(vBillNum=1, count({<Flag_Actionspaket={'1'}>} distinct %Key_Header),sum({<Flag_Actionspaket={'1'}>}Quantity)))

sum(aggr(if(vBillNum=1, count({<Flag_Actionspaket={'1'}>} distinct %Key_Header),sum({<Flag_Actionspaket={'1'}>}Quantity)),Dimensionfields))

Re: Totals in Pivot Table

psk180590 — Tue, 06 Feb 2018 10:42:08 GMT

Thanks Staffan,

The second option with Aggr suits my requirement.