topic Age classifications in QlikView

Age classifications

kmswetha — Tue, 19 Apr 2016 15:59:20 GMT

Hi,

Struck with the below aging bucket.

I have to classify <=30 ,>30,31-60

its a simple if is not going to multiple loops.

if(age<=30,'less than 30',

if(age>30,'greater than 30',

if(age>30 and age <60,'between 30 and 60')))

Problem here is once age goes to age>30, it doesn't go the next if.

How to deal this situation?

Any suggestions?

sunny_talwar — Tue, 19 Apr 2016 16:01:15 GMT

Why do you assign two text to single value? If a Age = 45 you want it to be called greater than 30 and between 30 and 60 at the same time?

Chanty4u — Tue, 19 Apr 2016 16:01:23 GMT

try this

if(age<=30,'less than 30', A1,

if(age>30,'greater than 30',A2

if(age>30 and age <60,'between 30 and 60' )))as A3

try to create in backend script and u will get flags in front end.

swuehl — Tue, 19 Apr 2016 16:03:40 GMT

You would need to create a table with multiple records for the same age, assigning different classes (Like a link table).

LOAD

age,

if(age<=30,'less than 30','greater than 30') as Class

FROM ...

CONCATENATE

LOAD

age,

'between 30 and 60' as Class

FROM ...

WHERE age > 30 and age <60;

edit: corrected second load

Colin-Albert — Tue, 19 Apr 2016 16:04:22 GMT

QlikView has a function class() that can group data into equal size bands in a simple command.

For different size bands then you will need to use if statements.

Just remember to make your column wide enough to see the results

kmswetha — Wed, 20 Apr 2016 12:53:05 GMT

I was also thinking same. Let me try and reply back to this post.

Thank Swuehl