topic Re: How do you use dimension in column? in QlikView

How do you use dimension in column?

Sun, 01 Jan 2012 08:00:43 GMT

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.

How do you use dimension in column?

lironbaram — Sun, 01 Jan 2012 08:05:40 GMT

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

How do you use dimension in column?

Sun, 01 Jan 2012 08:54:11 GMT

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.

Re: How do you use dimension in column?

lironbaram — Sun, 01 Jan 2012 09:07:26 GMT

hei

check the example hope it helps you

How do you use dimension in column?

Sun, 01 Jan 2012 09:35:54 GMT

Thanks for your prompt support. Very useful.