topic Pivot Table - reducing dimension in QlikView

Pivot Table - reducing dimension

lucarizziero — Tue, 07 Dec 2010 18:33:01 GMT

Hi,

I have a pivot table for which I need to reduce the dimensions aggregating the less recent.

For instance, I have the dimension named season contaning: 000, 021, 022, 031, 032, 041, 042, 051, 052, 061, 062, 071, 072, 081, 082, 091, 092, 101, 102, 111, 112, 121, 122

I'd need to obtain a pivot table with a column for each of the last 10 seasons (081, 082, 091, 092, 101, 102, 111, 112, 121, 122) plus one containing the valua of the residual seasons.

I tried using a concat function but it runs too slowly: anybody has any suggestion regarding this situation ?

Thanks

Luca

Pivot Table - reducing dimension

johnw — Tue, 07 Dec 2010 18:58:45 GMT

Perhaps add a SeasonGroup field. I'm sure what your actual logic for season is, so I can't give an exact expression, but this sort of form:

if(this is one of the last 10 seasons, Season, 'Others') as SeasonGroup

Pivot Table - reducing dimension

lucarizziero — Tue, 07 Dec 2010 19:29:54 GMT

Hi John,

But that field would not be influenced by the filters: while I need it.

Any suggestion regarding the use of a linear table instead of a pivot one ?

Thanks