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: 
Not applicable

compare date to yesterday

I have a date columm that I need to filter for the date of yesterday. I am not sure how to create such expresssion.

thanks in advance,

Haidar.

2 Replies
MayilVahanan

HI

Try like this

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

hope it helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
rustyfishbones
Master II
Master II

Or

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