topic Re: Get last 14 day data in QlikView

Get last 14 day data

anuradhaa — Wed, 25 Nov 2020 16:16:04 GMT

I have a date file in 03-JAN-16,........

I want to get last 14 days data inside expression on pivot table.

how do modify below expression to get ReloadTime-1 to ReloadTime-15. (That last 14 complete days)

Count({<MY_DATE = {"=MY_DATE >= ReloadTime()-14"}>} ABC)

Thanks,

sunny_talwar — Fri, 20 May 2016 03:49:22 GMT

May be this:

Count({<MY_DATE = {"$(='>=' & Date(Max({1}MY_DATE) - 14, 'DD-MMM-YY') & '<=' & Date(Max({1}MY_DATE), 'DD-MMM-YY'))}>} ABC)

or this

Count({<MY_DATE = {"$(='>=' & Date(Max(Floor(ReloadTime())) - 14, 'DD-MMM-YY') & '<=' &Date(Max(Floor(ReloadTime())), 'DD-MMM-YY'))}>} ABC)

anuradhaa — Fri, 20 May 2016 04:06:54 GMT

Not works, what i want is if today is 2016/05/28 i want to get data relevant to 2016/05/27 to (2016/05/27 - 14) days

(2016/05/13)

sunny_talwar — Fri, 20 May 2016 04:09:05 GMT

What about this:

Count({<MY_DATE = {"$(='>=' & Date(Today() - 15, 'YYYY/MM/DD') & '<=' & Date(Today() - 1, 'YYYY/MM/DD'))}>} ABC)

Not sure what your MY_DATE format is, but make sure you add that to the set expression above.