Grouping columns in a straight/pivot table

[sabreyals]

Hi All,

   is it possible to group columns in Qlikview like we do in list reports in other tools like Cognos etc.

I need my columns in a straight table/pivot table to be grouped like this:

A		J
B	C	K	L	M

Thanks

[#2]

These A,B,C,J,K,L,M  all are dimesions?

can you please tell your requirement a bit more

[ecolomer]

Yes it is possible

[sabreyals]

@ Pooja - B,C,K,L,M are all labels of the expressions, i have only one dimension.

A and J are just text.

@Enrique - Could you tell me how to achieve that. Which property of a straight/pivot tables allows me to pull text objects above the expression labels.

[ecolomer]

I used two dimensions and change the position by pivoting the elements

[jaimeaguilar]

Hi, you just have to drag the column that you want to traspose and you will see a blue arrow indicating the position where it will be dropped,

regards

[sabreyals]

I have only one dimension and a bunch of measures. The names of the measures are AB,AC,JK,JL,JM.

The idea was to have it represented in the grouped way with A on top and B and C below (same with JK,JL,JM) so that i  could save space horizontaly.

[sabreyals]

I believe you can do that with dimensions but i have only 1 dimension, i need to insert text labels above the measure cols so that i can group a couple of measures. Eg is in my reply to enrique.

This is possible in reporting tools like cognos by inserting list rows and list cells etc.

Is it possible in Qlikview?

[ecolomer]

For Grouping as you need, I separe a Variable in two elements