Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Karahs
Partner - Creator
Partner - Creator

Count of products for the last 3 days i.e today, yesterday & a day before yesterday using set analysis ??

Hello Everyone,

I would like to find the "Count of Products" for the last 3 days i.e today, yesterday and a day before yesterday

using set analysis. It should be dynamic so that as the days change I can get the information of the current day

and the previous 2 days as well.

Thanks in advance.

Regards,

Kshitija Shinde

2 Replies
MK_QSL
MVP
MVP

=COUNT({<Date= {">=$(=Date(Today()-2))<=$(=Date(Today()))"}>}Products)

or

=COUNT(Distinct {<Date= {">=$(=Date(Today()-2))<=$(=Date(Today()))"}>}Products)


Change field names accordingly

Silambarasan1306
Creator III
Creator III

The below expression will give the expected ans.

COUNT(Distinct {<Date= {">=$(=Date(Max(Date)-2))<=$(=Date(Max(Date)))"}>} Products)

Date - Change the column as per your convenience.