topic Re: To calculate max date-1 in QlikView

To calculate max date-1

yogitamehta10 — Mon, 10 Oct 2016 16:41:41 GMT

HI All,

i have date in my data as date dd/mm/yyyy

i need to calculate sale where date is maximum date of this date -1, in short i want the yeterday's day.

Thanks in advance

sunny_talwar — Mon, 10 Oct 2016 16:48:47 GMT

May be this:

Sum({<Date = {"$(=Date(Max(Date)-1, 'DD/MM/YYYY'))"}>} Sales)

Update: Missed -1 above

sunny_talwar — Mon, 10 Oct 2016 16:49:23 GMT

or for yesterday, you can use Today()

Sum({<Date = {"$(=Date(Today() - 1, 'DD/MM/YYYY'))"}>} Sales)