topic pivot table auto group by dimension in QlikView

pivot table auto group by dimension

Thu, 14 Oct 2010 15:14:39 GMT

How can i make a auto group by from dimensions in a pivot table.

My dimension has more than 10000 values and i wanna put them in groups.

<1000

1000-1099

1100-1199

enz

Is that possible and how?

greetz,

dirk groen

Thu, 14 Oct 2010 15:29:42 GMT

Hi,

Maybe you can use the function CLASS in your script load, and create a new field if the group that you want.

johnw — Fri, 15 Oct 2010 01:14:38 GMT

Perhaps this. The dual() function keeps them sorted in numeric order.

if(MyField<1000,dual('<1000',1)
,dual(floor(MyField,100)&'-'&(floor(MyField,100)+99),floor(MyField,100))) as MyNewfield

Fri, 15 Oct 2010 08:08:54 GMT

Thanks a lot. He works fine

Greetz,

Dirk Groen