Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
anuradhaa
Partner - Creator II
Partner - Creator II

Use Between inside set analysis

Hi,

I have date field called "Start Date" and it is in a format "10/31/2015  12:01:00 AM".

I want to get count(Start Date) for recent two dates.

If today is 2015/11/02 then i have to display 2015/11/02 and 2015/11/01.

I used =count({$<Start Date={"=Start Date>=Now(1)-2"}>}Country) as one expression and

=count({$<Start Date={"=Start Date>=Now(1)-1"}>}Country)

10 Replies
anuradhaa
Partner - Creator II
Partner - Creator II
Author

please check my attache excel sheet.

I have used your expression, but when i take Date(now()-2) and Date(now()-1)

It gives same vales