topic Re: PIVOT TABLE SUBTOTALS in QlikView

PIVOT TABLE SUBTOTALS

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

In the Pivot table attached above the subtotal of the column by year does not sum to the correct number. for example in 2015 numbers I get 337, but the total at the bottom displayed is 304.

Is their a way to take the subtotals in expression.

Don't know the reason have taken partial sums in pivot table for charge description.

Please help me to do.

Thanks,

Re: PIVOT TABLE SUBTOTALS

sunny_talwar — Wed, 14 Sep 2016 16:20:30 GMT

What is your expression?

May be use this:

Sum(Aggr(<YourExpression>, <YourDimensions>))

Re: PIVOT TABLE SUBTOTALS

bhavvibudagam — Wed, 14 Sep 2016 16:27:08 GMT

Hi,

I have taken pivot table with 2dimesntions charge_Description and year one expression

=Count({<ARCHRG.UCR_CODE={'90D','90E','90G'},AGE={"<21"}>}distinct ARMAINID)

Re: PIVOT TABLE SUBTOTALS

bhavvibudagam — Wed, 14 Sep 2016 16:31:46 GMT

not working above one can i include both dimensions

Re: PIVOT TABLE SUBTOTALS

sunny_talwar — Wed, 14 Sep 2016 16:37:27 GMT

So this isn't working?

=Sum(Aggr(Count({<ARCHRG.UCR_CODE={'90D','90E','90G'},AGE={"<21"}>}distinct ARMAINID), charge_Description, Year))

Re: PIVOT TABLE SUBTOTALS

bhavvibudagam — Wed, 14 Sep 2016 17:03:58 GMT

Not working showing zeros .

I need the subtotal the bottom one mentioned in red mark in the above attached image

Re: PIVOT TABLE SUBTOTALS

sunny_talwar — Wed, 14 Sep 2016 17:05:56 GMT

Would you be able to share a sample?

Re: PIVOT TABLE SUBTOTALS

bhavvibudagam — Wed, 14 Sep 2016 17:13:50 GMT

its in server unable to upload.

The issue is in the attached pivot table image at the subtotal for example for the year 2015 the count is 337 but getting 304.

the expression used is

=Count({<ARCHRG.UCR_CODE={'90D','90E','90G'},AGE={"<21"}>}distinct ARMAINID)

PIVOT TABLE SUBTOTALS

dimensions charge_Description,year