topic Re: Pivot table in QlikView

Pivot table

Fri, 29 May 2015 13:31:45 GMT

Hi,

trying to to make a pivot in QV, eqvivalent of the below excel one. I cannot figure out how to do it.

Any ideas?

Pls find attached excel example and QV file.

Regards,

Olle

Clever_Anjos — Fri, 29 May 2015 13:38:28 GMT

Please mark "Indent mode" at Style Tab

Clever_Anjos — Fri, 29 May 2015 13:39:35 GMT

And "SubTotals on Top" at Presentation tab

awhitfield — Fri, 29 May 2015 13:43:15 GMT

Hi Olle,

if you tweek alignments on the rightmost chart and set it to fully expanded, then it's pretty close:

awhitfield — Fri, 29 May 2015 14:27:56 GMT

HI Olle,

glad it worked, you were SO close!

Have a good Day and a nice weekend !!