Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Rolling Date Bucket List Boxes

Looking to create a list box that has four options.

Less than 30 days

Less than 60 days

Less than 90 days

More than 90 days

However everything I have done so far has made 30 day buckets instead. In other words:

0 to 30 days

31 - 60 days

61 - 90 days

90+ days

That wont work for what I need.

What I tried:

=AGGR(

If(WO_Days_Difference >0 and WO_Days_Difference <31, '30 Days or Less',

If(WO_Days_Difference >0 and WO_Days_Difference <61, '60 Days or Less',

If(WO_Days_Difference >0 and WO_Days_Difference <91, '90 Days or Less',

If(WO_Days_Difference >0 and WO_Days_Difference >90, '90 Days or More'))))

, WO_Days_Difference)

1 Solution

Accepted Solutions
danieloberbilli
Valued Contributor II

Re: Rolling Date Bucket List Boxes

I would suggest to solve this in the script: create a field for each bucket to flag if the sales goes in this bucket...then use crosstable to combine the fields in one single field.

PFA the qvw.

3 Replies
danieloberbilli
Valued Contributor II

Re: Rolling Date Bucket List Boxes

I would suggest to solve this in the script: create a field for each bucket to flag if the sales goes in this bucket...then use crosstable to combine the fields in one single field.

PFA the qvw.

Not applicable

Re: Rolling Date Bucket List Boxes

That worked great. Would have been nice to been able to do it in an expression, but whatever works!

sli
Valued Contributor II

Re: Rolling Date Bucket List Boxes

Thanks for following up Trey- thanks for marking your question as answered which awards points to the members who helped you out.

Best Regards, Sara

Community Browser