topic Re: Age Bucket in QlikView

Age Bucket

qlikwiz123 — Sat, 16 Nov 2024 19:54:45 GMT

I need to create Age Buckets based on the values as follows

1 Day

7 Days

30 Days

60 Days

All

I know how to create the bucket but not sure how to get 'All' as one of the values. 'All' should give all the days from Day 1 to last day.

if(DateAge=1,'1Day',
if(DateAge<=7,'7 Days',
if(DateAge<=30,'30 Days',

if(DateAge<=60,'60 Days',
))))

This works but how do I add 'All' to this condition? Note that I don't know what the maximum number of days can be; so it should be dynamic

Re: Age Bucket

Vegar — Sat, 12 Oct 2019 05:56:46 GMT

You can not add more than one value to a field so you can not add an IF... to add 'All' to all.

You will need to create an DateAge dimension table to get this feature. Where you load all DateAge as a key to your transaction, add your current if statement for [Age bucket] and theb concatenate all DateAge again, but this time add 'All' as [Age bucket].

Re: Age Bucket

Brett_Bleess — Wed, 16 Oct 2019 16:07:42 GMT

In addition to Vegar's post, here is a Design Blog post that may further help:

https://community.qlik.com/t5/Qlik-Design-Blog/Buckets/ba-p/1463216

Cheers,
Brett

Re: Age Bucket

Victor_Alumanah — Wed, 16 Oct 2019 16:23:22 GMT

Maybe you can load the field in twice, once in buckets and the second time for All.

Re: Age Bucket

Arthur_Fong — Thu, 17 Oct 2019 04:43:49 GMT

I have a sample app here, check this out:

https://community.qlik.com/t5/QlikView-App-Development/Create-a-third-bucket-based-on-first-and-second-bucket/m-p/1633452#M446635

Thanks and regards,

Arthur Fong

Re: Age Bucket

Brett_Bleess — Thu, 17 Oct 2019 12:08:14 GMT

You have quite a few posts at this point, please be sure you use the Accept as Solution button on the one(s) that helped you get things working, or if you do something on your own, consider posting that and mark it, and if you are still struggling after looking over all the posts, leave an update for everyone, and I am sure someone will shout back as quickly as they can.

Regards,
Brett