How to create Days bucket

nehasaxena — Thu, 05 Jan 2017 06:41:05 GMT

Hi All,

I need to display day bucket as X axis in one chart. The chart shows the data to get the info that how much data is pending from how many days (See the image).

Formula to calculate days - Num(EffectiveDate - Today())

Can we create the bucket like in expected image?

Let me know if you need more info.

Thanks.

Best Regards,

Neha

Re: How to create Days bucket

marcus_sommer — Thu, 05 Jan 2017 07:48:24 GMT

You need to create a calculated dimension for it in logic of this:

if(EffectiveDate - Today() <= 1, dual('0-1 days', 1),

if(EffectiveDate - Today() <= 3, dual('2-3 days', 2),

if(EffectiveDate - Today() <= 7, dual('1 week', 3),

...

and then as chart-expression something like: count(YourID)

Instead of an if-loop could be also a pick(match()) used or you might transfer it into the script by using Mapping … and not the geographical kind.

- Marcus

topic How to create Days bucket in QlikView

How to create Days bucket

Re: How to create Days bucket