topic Re: Rolling Date Bucket List Boxes in QlikView

Rolling Date Bucket List Boxes

Wed, 29 Apr 2015 23:25:40 GMT

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)

Re: Rolling Date Bucket List Boxes

danieloberbilli — Wed, 29 Apr 2015 23:47:11 GMT

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.

Re: Rolling Date Bucket List Boxes

Thu, 30 Apr 2015 00:11:56 GMT

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

Re: Rolling Date Bucket List Boxes

Anonymous — Thu, 30 Apr 2015 00:23:26 GMT

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