unpivot a single table into multiple columns qliksense

[Qlikuser09]

I have a pivot table with 100 columns, is there a way I could group 10 columns under one group, and the next 10 in another sub-group and so on, with the drill-down functionality between them

[AshutoshBhumkar]

Hi,

Maybe you can create 10 different datasets using crosstable() function and concatenate them.Create flag for group in each dataset.

Thanks,

Ashutosh

[Qlikuser09]

How to create data sets??? like a separate table?

[AshutoshBhumkar]

Yes.  10 different data set with 10 columns each.