topic Re: Move Dimensions to Top in QlikView

Move Dimensions to Top

hschultz — Wed, 08 May 2013 09:31:50 GMT

Hi all

I hope you can be of some assistance please.

We want to have a straight table (or a pivot for that matter), with calculations running down on the left, and each dimension as it's own colum.

It's best to try and explain with viewing the attached Qvw.

I know a pivot table just moves to the top, but it STILL doesn't give a line per each calculation.

I suspect there is a very simple way to this by editing the chart properties, but i cannot seem to find something like that. Otherwise how does one approach an issue like this?

Thank you all in advance.

Re: Move Dimensions to Top

giakoum — Wed, 08 May 2013 09:34:50 GMT

just change it to pivot and drag columns and expressions as desired. See attcahed.

Re: Move Dimensions to Top

hschultz — Wed, 08 May 2013 09:46:41 GMT

Oh ok! Stupid mistake from my side -I see that i missed the part where i drag the calculations to the side....

This is exactly what i need, thank you

Re: Move Dimensions to Top

Wed, 08 May 2013 09:48:23 GMT

Heinrich,

> Convert your Straight to Pivot..

> Drag your expression to the left most (relacing your Dimensions)

> Drag your dimension horizontally...

see the attached I have created one for you in the same example of yours

Re: Move Dimensions to Top

hschultz — Wed, 08 May 2013 13:21:27 GMT

Hi guys, this works great, but there is 1 problem:

It seems that i cannot set individual comlum widths. If i change the size to view entire Expression, it makes all the value colums bigger as well.

Is there a way to chenge each individually?