Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

date today -1

What would be the statement to only grab on a refresh today and only grab dispense dates of yesterday?

Where DispenseDt=today-1 as (DispenseDt);

4 Replies

Re: date today -1

This along should work:

Where DispenseDt = Today(1) - 1;

Not applicable

Re: date today -1

Re: date today -1

You are doing this in SQL, try this:

Where DispenseDt = SYSDATE - 1;

rupamjyotidas
Valued Contributor

Re: date today -1

or

Where DispenseDt=CURDATE()-1

or

Where DispenseDt=GetDate()-1

Do check if DispenseDt date is only date or timestamp