topic Re: How to create Age Bucket using Listbox Object? in QlikView

How to create Age Bucket using Listbox Object?

Fri, 10 Apr 2015 04:47:42 GMT

Hi,

I am new to Qlikview, My requirement is:

I have a table Called age.

Age:

LOAD * INLINE [

Age

];

Now I want create a Bucket Using class Function in Listbox, Can please let me know. Step by step.

Requirement is like:

List Box:

Age

11-20 | 21-30 |31-40 | 41-50 | 51-60 Like this type i need.

Thanks,

Kumor

Re: How to create Age Bucket using Listbox Object?

ashwanin — Fri, 10 Apr 2015 07:42:44 GMT

Use class fucntion

Dual(Replace(Class(Age,10),'<= x <','to'), Num(Class(Age,10))) as Bucket

Script should be :

BUCKET:

LOAD * INLINE [

Age

];

load *,

Dual(Replace(Class(Age,10),'<= x <','to'), Num(Class(Age,10))) as Bucket

resident BUCKET;

Re: How to create Age Bucket using Listbox Object?

robert_mika — Fri, 10 Apr 2015 07:56:49 GMT

Listbox--->Field-->Expression

Type

=class(Age,10,'Age',11)

This is the closer you can get

You can change the expression to

=class(Age,10,'Age',10) to have bucket every 10 years

Age- is your field

10- is the bucket (every 10

'Age' is the text you can have between(you can change that to anything you like)

10- number where you want to start from

Re: How to create Age Bucket using Listbox Object?

nagarjuna_kotha — Fri, 10 Apr 2015 08:07:47 GMT

Hi ,

By using Class Function we can solve this Problem.

EX:

In List Box >>> Properties >> Field>>>Expression>>>Class(Age,Range,'Age',Range+1)

Regards,

Nagarjuna

Re: How to create Age Bucket using Listbox Object?

ankitaag — Fri, 10 Apr 2015 08:30:30 GMT

Hello Reddy,

Create a ListBox, in the General tab select Expression in field dropdown and write

=Class(Age,10,'Age',11)

as an expression.

This will give you the below result:

Since the upper limit is not included in the range that's why the result says Age >=11 and <21

and that upper limit is included in the next range which says Age >=21 and <31

Re: How to create Age Bucket using Listbox Object?

Fri, 10 Apr 2015 08:34:42 GMT

Thanks Ashwani Kumar

Re: How to create Age Bucket using Listbox Object?

Fri, 10 Apr 2015 08:35:44 GMT

Thanks to all.

Re: How to create Age Bucket using Listbox Object?

Fri, 10 Apr 2015 08:37:05 GMT

Can you guys suggest me What type scenarios We can use ? What is the Use? Why ? is there any limitations?

Re: How to create Age Bucket using Listbox Object?

ankitaag — Fri, 10 Apr 2015 08:44:56 GMT

The class function is mostly used when you need to calculate the aging of your inventory. In simple words when you need to check that the items or products which you have are how much old, so that you can take better decisions that whether you need to discard those too old items or how to sell them.

Also, when you need to make a range for students' marks, to identify in which score range the student fall.

Awesome function with the help of which you can make range buckets on the fly.

Re: How to create Age Bucket using Listbox Object?

Fri, 10 Apr 2015 09:02:00 GMT

I agree with your terms, Can you tell me in Advanced Level, Present u told me that, i think as Beginner Level, Kindly Give Bit Explanation in Advanced Script Level.

Thank you

Re: How to create Age Bucket using Listbox Object?

buzzy996 — Fri, 10 Apr 2015 09:25:47 GMT

it's applicable for most of the domains,

as a BA/Report annalist will look for ,

,which is the age group took more insurances?

which is the age group buying products?

which is the age group buying gadgets?

...etc

Re: How to create Age Bucket using Listbox Object?

Fri, 10 Apr 2015 09:36:11 GMT

Yes, Shiva Reddy.

Thank you.

Re: How to create Age Bucket using Listbox Object?

Fri, 10 Apr 2015 09:38:43 GMT

When we writing the Script We know that we are using (Comma, and ' | ', and '&' Symbole and Etc.....)

This things in all Business area like Sql = Qlikview Script Level it's Same ?

Thanks,

Re: How to create Age Bucket using Listbox Object?

hariprasadqv — Fri, 10 Apr 2015 09:55:36 GMT

PFA. It might help you.

Re: How to create Age Bucket using Listbox Object?

Fri, 10 Apr 2015 12:02:45 GMT

Sure Hari... Go head