topic Re: Score Listing - Grouping ? in QlikView

Score Listing - Grouping ?

Wed, 27 Aug 2014 15:18:05 GMT

Have a bunch of scores list ranging from 1-100. I need groupings in the following order 25:50:75:100.

If score = 0 to 25 then it is in the Group 1

If score = 25 to 50 then it is in the Group 2

If score = 50 to 75 then it is in the Group 3

If score = 75 to 100 then it is in the Group 4

Appreciate help

Re: Score Listing - Grouping ?

Wed, 27 Aug 2014 17:57:40 GMT

You may want to utilize the Class function

Re: Score Listing - Grouping ?

Wed, 27 Aug 2014 17:59:14 GMT

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'