topic Re: Current Date vs Previous Day in QlikView

Current Date vs Previous Day

Mon, 16 Feb 2015 20:40:57 GMT

In Crystal Reports I am able to use the Current() function to get today's date and then I can say Current()-1 to get the previous day. How can I accomplish the same thing in Qlikview:? Better yet, how can I make previous day (NOT previous month or previous year) as a variable?

Alex

Re: Current Date vs Previous Day

sunny_talwar — Tue, 17 Feb 2015 02:27:37 GMT

From what I understand this is what you are trying to accomplish:

Define your variable like this may be

vPrevious = Date(Num(Today()) -1)

If this is not what you are looking for, then please elaborate.

Best,

Re: Current Date vs Previous Day

jagan — Tue, 17 Feb 2015 03:48:28 GMT

Hi,

Try like this

For getting Today's date use Today()

For getting Yesterday's date use Date(Today() - 1)

To use this in Set analysis

For Current Date:

Sum({<DateFieldName={'$(=Today())'}>} Sales)

For Yesterday Date:

Sum({<DateFieldName={'$(=Date(Today() - 1))'}>} Sales)

Hope it helps you.

Regards,

Jagan.