topic Re: Dimensions in one column in QlikView

Dimensions in one column

Anonymous — Fri, 11 Mar 2011 16:47:09 GMT

Hi,

Question about dimensions in a straight table / pivot table.
I would like to have three dimensions in one column. For three different dimensions I would like to see the same expression (sum of sales).
At this moment I have exactly what I need, but I don't like the layout of the table.
In column 1, line 1, I see the first dimension. In column 2, line 2, I see the second dimension, etc.
I would like to see all the dimensions in the first column. Is this possible?

Thanks in advance for your help!

Henco

Dimensions in one column

Fri, 11 Mar 2011 17:55:37 GMT

clicking 'Indent mode' in the style tab can approximate what you need

Dimensions in one column

Anonymous — Fri, 11 Mar 2011 22:07:02 GMT

Thanks for your reply.
It works exactly as I wish to, but it should be nice if I could give the different dimensions a label.
I think that's not possible with this option? So, I would like to see al the labels of the dimension in the first column.

Re: Dimensions in one column

Tue, 09 Apr 2013 13:59:41 GMT

Can you not have multiple dimensions in the first column based on some conditions? like;

if (condition 1, dimeinsion1, if (condition2, dimension2, dimension 3))

This way you can have all in one column.

Re: Dimensions in one column

Thu, 19 Jun 2014 09:25:45 GMT

Does somebody know if it's possible to have the values of different dimensions in one column?

I need to have each value of five dimensions each in a new row.

Preferably in a pivot table

Re: Dimensions in one column

Anonymous — Thu, 19 Jun 2014 09:42:46 GMT

Hi,

Properties-->style tab---> indent mode (check)

Hope this may help.

Re: Dimensions in one column

Thu, 19 Jun 2014 11:51:12 GMT

Thank you, Nisha, for your reply, only thing is that this only changes the view of my pivot.

What I realy need is to have each separate value in it's own row/cell.

Perhaps you, or someone else, can provide me with a statement that arranges these separate dimensions in one column, without the indent mode.