topic Re: Total column in pivot table in QlikView

Total column in pivot table

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

Hi Experts,

I have pivot table with a dimension set to horizontal.

I want the TOTAL column by counting all the YES values for both dimensions. I did this by enabling show partial sum on the 2nd dimension, how how can i count(BranchNo) ?

Also, i want this TOTAL column to sit vertically beside the Location dimension. I am not sure how to achieve this.

Please help.

Re: Total column in pivot table

CarlosAMonroy — Wed, 02 Aug 2017 14:43:39 GMT

Hi Suraj,

Maybe you can try the following expression, it will sum the Y and N.

Yes:

if(Qty = 'Y',count( Qty))

No:

if(Qty = 'Y',count( Qty))

Hope that helps.

Carlos

Re: Total column in pivot table

surajap123 — Wed, 02 Aug 2017 14:52:31 GMT

Hi Carlos,

Thanks for your reply.

I want only Y and N for the chart expressions.

I only want the count in the TOTAL column.

Re: Total column in pivot table

krishnacbe — Wed, 02 Aug 2017 14:59:15 GMT

Hi,

Please find the attached. hope that helps

Re: Total column in pivot table

surajap123 — Wed, 02 Aug 2017 15:13:53 GMT

I think i didn't explain my requirement properly.

I don't want to change my existing expressions in the chart.

I only wan to have a new column that tells the total count of 'Y' values, beside the location column.

Thanks.

Re: Total column in pivot table

vishsaggi — Wed, 02 Aug 2017 16:53:23 GMT

something like this?

Re: Total column in pivot table

sunny_talwar — Wed, 02 Aug 2017 17:13:59 GMT

May be like this?

=Location & ' Count: ' & Aggr(Count(DISTINCT{<Qty = {'Y'}>}[Branch No]), Product, Location)