Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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

Re: compare date to yesterday

HI

Try like this

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

hope it helps

rustyfishbones
Honored Contributor II

Re: compare date to yesterday

Or

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

Community Browser