topic Re: Individual Column Total from pivot table in QlikView

Individual Column Total from pivot table

deekey2 — Thu, 04 Nov 2021 11:14:05 GMT

Hi All,

I created a pivot table as below. And I would like to calculate the % of each column so I tried to get the total of each column first. But when I use Sum(Total QTY) to get column total(e.g. 147 as below), it shows the sum of all columns total(e.g. 43,418).

And I expect to sum the column total like

first column NC01 > 15+44+25+34+18+6+5 = 147

Any suggestions? Thanks a lot.

Re: Individual Column Total from pivot table

NitinK7 — Thu, 04 Nov 2021 11:52:29 GMT

Might be there duplicated values in your data table, please check once

Re: Individual Column Total from pivot table

deekey2 — Fri, 05 Nov 2021 08:15:00 GMT

checked, no duplicated values.

seem Sum(Total QTY) returns total QTY of all cells..

Re: Individual Column Total from pivot table

NitinK7 — Fri, 05 Nov 2021 09:45:05 GMT

if possible can you please share your QVF file with only this single table

Re: Individual Column Total from pivot table

deekey2 — Fri, 05 Nov 2021 10:59:29 GMT

Thanks. I found why...

As you read the following output, it is prefect when I don't filter out "Type=D" in table 1..

but in my case, I expect to display D and E only(e.g. table 2), and calculate the individual column %, any suggestions?

I attached the QVF for you reference..

Regards,

Re: Individual Column Total from pivot table

NitinK7 — Fri, 05 Nov 2021 11:10:04 GMT

I didn't understand

calculate the individual column %.

if possible can you share with example what you actually want?

Re: Individual Column Total from pivot table

NitinK7 — Fri, 05 Nov 2021 11:46:57 GMT

find the QVF and table 3

for Type column I have wrote set expression, might be you want like this

and there seems there allready individual column % are calculated