Group Experience

Wed, 11 Sep 2013 05:29:06 GMT

Hi Folks,

I have a field Exp. which have values 1 to 20. I have to group the Exp as 1-5 yrs, 6-10 yrs and +10 yrs in drill down.

Plz help.

Re: Group Experience

Greg_Williams — Wed, 11 Sep 2013 05:59:37 GMT

Have you tried using the Class() function?

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'

I find it useful when creating buckets for data.

Also, consider using a variable in the arguments to make it dynamic. For instance, a user can slide the value up or down to increase or decrease the items in the buckets.

Regards,

Greg

Re: Group Experience

Wed, 11 Sep 2013 06:52:24 GMT

thanks Greg,

I have to use this in pie chart. user dont have to make a any input just

have to click the Experience to move ahead.

topic Group Experience in QlikView

Group Experience

Re: Group Experience

Re: Group Experience