topic Re: 'if' problem in QlikView

'if' problem

Sun, 12 Aug 2012 06:10:30 GMT

Hey , i want to create a listbox for age group.

Ex:

AgeGroup

1-10

10-20

20-30

30-40

40-50

Above 50

I am using:

(Age>=10, '1-10',
if(Age>=20, '10-20',
if(Age>=20, '20-30',
if(Age>=30, '30-40',
if(Age>=40, '40-50',
if(Age>=50, 'Above 50')))))) as

AgeGroup

But i am getting:

AgeGroup

1-10

can anybody please tell me what mistake i am doing..........

Re: 'if' problem

Sun, 12 Aug 2012 08:01:32 GMT

the problem is all of them are >=10, son try using:

(Age>=50, 'Above 50',
if(Age>=40, '40-50',
if(Age>=30, '30-40',
if(Age>=20, '20-30',
if(Age>=10, '10-20','<10'))))) as

AgeGroup

Re: 'if' problem

MayilVahanan — Sun, 12 Aug 2012 10:10:50 GMT

Try like this

(Age<=10 and Age>=1, '1-10',
if(Age<=20, '11-20',
if(Age<=30, '21-30',
if(Age<=40, '31-40',
if(Age<=50, '41-50', 'Above 50'))))) as

AgeGroup

Hope it helps

Re: 'if' problem

Mon, 13 Aug 2012 07:05:39 GMT

Please use CLASS!

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'