Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am using a pivot table and wish to use another dimension in columns. Effectively dimensions in both rows and columns. Can someone provide a sample code / steps of how to achieve this in Qlikview.
hei you just need to make sure
that in the chart properties in the presention tab
the "allow pivoting" is checked
then you just drag the dimension you want to use as column up
you will see a blue arrow as it changes from vertical to horizontal
I will need to explain my problem in detail.
I want the pivot table to look like this. I need aggregation of hours by level for a given SBU. Both Level and SBU are dimensions. Std Hours and Paid Vac are based on type of hours booked.
SBU #1 SBU#2 SBU#3 ...
Std Hours
Level 1
Level 2
Level 3
Paid Vac
Level 1
Level 2
Level 3
Thanks.
hei
check the example hope it helps you
Thanks for your prompt support. Very useful.