topic Re: Count days (today vs a date) in QlikView

Count days (today vs a date)

Anonymous — Mon, 27 Nov 2017 06:58:06 GMT

Hi,

I have ORDERDATE in the script (as YYYY-MM-DD). I want have a graph where I can see how many orders I have with 50-100 days between Today and Orderdate, how many with 100-200 days between Today and Orderdate and so on. I tried to count the days in the script, also using Interval, but didn't get it to work. What to do?

Re: Count days (today vs a date)

Anil_Babu_Samineni — Mon, 27 Nov 2017 07:01:21 GMT

Perhaps this?

If((Today() - ORDERDATE) >= 50 and (Today() - ORDERDATE) <= 100, Dual('50-100', 1),

If((Today() - ORDERDATE) >= 100 and (Today() - ORDERDATE) <= 200, Dual('100-200', 2)))

Re: Count days (today vs a date)

luismadriz — Mon, 27 Nov 2017 07:21:44 GMT

Hi Mariana,

In addition you could also use a class function to create a new field. The only thing is that the groups are equally spaced in terms of the numbers of days,

LOAD *,

Class(Today()-ORDERDATE, 50, 'days') As OrderDays;

LOAD ... or the Order table

I hope this helps,

Cheers,

Luis

Re: Count days (today vs a date)

Anonymous — Mon, 27 Nov 2017 11:47:06 GMT

Thank you!