topic Re: Pivot table column made whith value/total in QlikView

Pivot table column made whith value/total

Tue, 30 Oct 2012 17:09:59 GMT

Hi,

the excell attached is an extract of a qview pivot table, I would like make in the pivot table the same I made in column 'H' which is a simple quotient between each value of dimension TTOO and their nearest total amount.

By the way, I would also like to show only the TTOO representing the 80% of the total expression 'Prod', groupping the rest of TTOO in a summarized label 'REST OF TTOO'. Where should I touch to get this?

Thanks a lot

Re: Pivot table column made whith value/total

Gysbert_Wassenaar — Tue, 30 Oct 2012 17:43:36 GMT

See attached example. If you don't have QV11 you won't be able to see the grouping since that uses dimension limits specific to QV11. You may want to change the Include Boundary Values option if the top 80% should not go over the 80% total.

Re: Pivot table column made whith value/total

Tue, 30 Oct 2012 18:15:23 GMT

Thank you Gysbert it works.