topic Grouping in QlikView

Grouping

Wed, 09 Dec 2009 14:05:32 GMT

Hi guys/gals,

Please refresh my memory. I need to display the number of employees per age group:

Example:

20 <= x < 30

But I can;t remember which function to use 🙂

Regards,

Werner

Grouping

Wed, 09 Dec 2009 14:08:39 GMT

Hi Werner,

look for "CLASS()"!!!

Good luck!

Rainer

Grouping

Wed, 09 Dec 2009 14:11:19 GMT

Super!!!

Thx.

Grouping

Wed, 09 Dec 2009 15:54:03 GMT

When i read from reference manual couldn't understand the concept. could you please tell me how it works?

class( expression, interval [ , label [ , offset ]] )

Creates a classification of expressions. The bin width is determined by the number set as interval. The result is shown as a<=x<b, where a and b are the upper and lower limits of the bin. The x can be replaced by an arbitrary string stated in label. 0 is normally the default starting point of the classification. This can be changed by adding an offset.

Examples:

class( var,10 ) with var = 23 returns '20<=x<30'

class( var,5,'value' ) with var = 23 returns '20<= value <25'

class( var,10,'x',5 ) with var = 23 returns '15<=x<25'

-Raghu.

Grouping

Wed, 09 Dec 2009 15:58:12 GMT

Hi,

see the attached example.

Good luck!

Rainer