Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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