topic Re: Creating user defined Age bucket in List box in QlikView

Creating user defined Age bucket in List box

gizzel123 — Mon, 10 Nov 2014 11:47:41 GMT

Hi i have a column "Age".

I need to create an age bucket which should have an interval of 5 yrs..

like- (0-5),

(5-10),

(10-15)..... and so on.

Can u guys plz help..

thanks in advance

Re: Creating user defined Age bucket in List box

Mon, 10 Nov 2014 11:50:23 GMT

try this

class(age,15,x,5)

Re: Creating user defined Age bucket in List box

Mon, 10 Nov 2014 11:51:23 GMT

Use class function

Class(Age,5) as Age

Re: Creating user defined Age bucket in List box

Mon, 10 Nov 2014 12:02:55 GMT

Hi,

Like this u can create a Bucket.

If( age>0 and age<=5,'0-5',

If( age>5 and age<=10,'5-10',

If( age>10 and age<=15,'10-15',

If( age>15 and age<=20,'15-20','20 Above') as Age_Flag

Re: Creating user defined Age bucket in List box

Mon, 10 Nov 2014 12:04:39 GMT

sorry

try this

class(age,x,5)

Re: Creating user defined Age bucket in List box

gizzel123 — Mon, 10 Nov 2014 12:17:40 GMT

I used Class(Age,5) but then m getting 0,5,10,15.......

For "0"selection -ages are0-4,

"5"selection -ages are5-10,.....so on

How would i Define the displaying string too

cz when i use class(age,15,x,5) it display -x as bad field name..

Re: Creating user defined Age bucket in List box

gizzel123 — Mon, 10 Nov 2014 12:23:53 GMT

I tried in chart...its working fine ..but not in list box.

Re: Creating user defined Age bucket in List box

Mon, 10 Nov 2014 12:27:16 GMT

can u tell me what u have written in chart and we let u know why it is not working in listbox

Re: Creating user defined Age bucket in List box

gizzel123 — Mon, 10 Nov 2014 12:30:53 GMT

its working..i tried creating another list box...

Thanks All

Re: Creating user defined Age bucket in List box

Mon, 10 Nov 2014 12:33:55 GMT

thanks for marking as correct answer ,

pls let me know which expression is suits for u