topic grouping numeric values in QlikView

grouping numeric values

Wed, 24 Mar 2010 18:15:50 GMT

Hi,

I have a field on a table which takes numeric values which can range from 1 through to , lets say, 97 although the upper value can be any number

I want to be able to write, ? a mapping, ? which will group these numbers as

Number Group

1 1

2 2

3 3

4 4+

5 4+

etc

but it must be able to capture all possible number from 4 up to the highest number into the 4+ group.

Any ideas?

Thanks

vgutkovsky — Wed, 24 Mar 2010 19:01:18 GMT

I would recommend using a simple IF statement since your group# = your number. It would look like this:

if(number<4,number,'4+') as Group;

Regards,

Wed, 24 Mar 2010 19:01:45 GMT

Hi,

eg use this as expression:

if(ProductCode<4, ProductCode,'4+')

Greetings,

Piet