topic compare date to yesterday in QlikView https://community.qlik.com/t5/QlikView/compare-date-to-yesterday/m-p/422007#M484688 <HTML><HEAD></HEAD><BODY><P>I have a date columm that I need to filter for the date of yesterday. I am not sure how to create such expresssion. </P><P>thanks in advance, </P><P>Haidar.</P></BODY></HTML> Wed, 29 May 2013 22:30:32 GMT 2013-05-29T22:30:32Z compare date to yesterday https://community.qlik.com/t5/QlikView/compare-date-to-yesterday/m-p/422007#M484688 <HTML><HEAD></HEAD><BODY><P>I have a date columm that I need to filter for the date of yesterday. I am not sure how to create such expresssion. </P><P>thanks in advance, </P><P>Haidar.</P></BODY></HTML> Wed, 29 May 2013 22:30:32 GMT https://community.qlik.com/t5/QlikView/compare-date-to-yesterday/m-p/422007#M484688 2013-05-29T22:30:32Z Re: compare date to yesterday https://community.qlik.com/t5/QlikView/compare-date-to-yesterday/m-p/422008#M484689 <HTML><HEAD></HEAD><BODY><P>HI</P><P></P><P>Try like this</P><P></P><P>=Sum({&lt;Date = {'$(=Date(Max(Date)-1))'}&gt;}Sales)</P><P></P><P>hope it helps</P></BODY></HTML> Wed, 29 May 2013 22:50:45 GMT https://community.qlik.com/t5/QlikView/compare-date-to-yesterday/m-p/422008#M484689 MayilVahanan 2013-05-29T22:50:45Z Re: compare date to yesterday https://community.qlik.com/t5/QlikView/compare-date-to-yesterday/m-p/422009#M484690 <HTML><HEAD></HEAD><BODY><P>Or</P><P></P><P>=SUM ({&lt;Date = {'$(=Date (Today ()-1))'}&gt;} Sales)</P></BODY></HTML> Wed, 29 May 2013 23:34:51 GMT https://community.qlik.com/t5/QlikView/compare-date-to-yesterday/m-p/422009#M484690 rustyfishbones 2013-05-29T23:34:51Z