topic Re: Grouping columns in a straight/pivot table in QlikView

Grouping columns in a straight/pivot table

sabreyals — Thu, 06 Nov 2014 21:36:57 GMT

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

Re: Grouping columns in a straight/pivot table

Thu, 06 Nov 2014 21:43:18 GMT

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

can you please tell your requirement a bit more

Re: Grouping columns in a straight/pivot table

ecolomer — Thu, 06 Nov 2014 21:46:23 GMT

Yes it is possible

Re: Grouping columns in a straight/pivot table

sabreyals — Thu, 06 Nov 2014 21:51:38 GMT

@ 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.

Re: Grouping columns in a straight/pivot table

ecolomer — Thu, 06 Nov 2014 21:56:17 GMT

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

Re: Grouping columns in a straight/pivot table

jaimeaguilar — Thu, 06 Nov 2014 22:01:33 GMT

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

Re: Grouping columns in a straight/pivot table

sabreyals — Thu, 06 Nov 2014 23:09:25 GMT

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.

Re: Grouping columns in a straight/pivot table

sabreyals — Thu, 06 Nov 2014 23:11:40 GMT

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?

Re: Grouping columns in a straight/pivot table

ecolomer — Fri, 07 Nov 2014 03:16:53 GMT

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