topic Re: Pivot Table in QlikView

Pivot Table

Anonymous — Fri, 06 Mar 2015 16:53:49 GMT

Hi guys,

I have a pivot table but what I would like to do is put the sizes along the top and sum the physical and the free columns per size

I would like the output to look like this

30S 40R 42L 42R 44L

1 20 8 1 35

Is this possible with the expression somehow?

Thanks!

Re: Pivot Table

Gysbert_Wassenaar — Fri, 06 Mar 2015 17:36:17 GMT

Drag the Size header to the right and just above the expression. When you see a horizontal blue line let go and the Size dimension should be pivoted like you want.

Re: Pivot Table

Anonymous — Fri, 06 Mar 2015 17:46:20 GMT

Amazing. Who knew it was something so simple!

Thanks Gysbert

Re: Pivot Table

Anonymous — Mon, 09 Mar 2015 13:43:28 GMT

Hi guys,

Would you happen to know how to sort the size from S to XL on the top row

Thanks!

Re: Pivot Table

Gysbert_Wassenaar — Mon, 09 Mar 2015 14:17:25 GMT

Sort that dimension by this expression: =match(only({1}Size),'XS','S','M','L','XL')

Re: Pivot Table

Anonymous — Mon, 09 Mar 2015 14:36:07 GMT

I tried that but it didn't work..

Thanks a lot for your help so far though

Re: Pivot Table

Gysbert_Wassenaar — Mon, 09 Mar 2015 14:48:36 GMT

Oops, typo. Change {$1} into {1}.

Re: Pivot Table

Anonymous — Mon, 09 Mar 2015 15:12:20 GMT

Brilliant! Thanks a lot