topic Re: Set Analysis - Date in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis-Date/m-p/1140902#M893889 <HTML><HEAD></HEAD><BODY><P>Kushal</P><P></P><P>Thanks! Works perfectly.</P><P></P><P>Shamit</P></BODY></HTML> Sat, 06 Aug 2016 06:04:56 GMT shamitshah 2016-08-06T06:04:56Z Set Analysis - Date https://community.qlik.com/t5/QlikView/Set-Analysis-Date/m-p/1140900#M893887 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Please see attached file.</P><P></P><P>I am trying to get Column B to be the selected date-2, but I am not getting any figures.</P><P></P><P>I have the expression as</P><P></P><P>=Sum({&lt;SalesDate={"$(=Max(SalesDate)-2)"}&gt;}Sales)</P><P></P><P>Column A works fine.</P><P></P><P>Any ideas?</P><P></P><P>Thanks</P><P>Shamit</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-Date/m-p/1140900#M893887 shamitshah 2020-11-25T16:16:04Z Re: Set Analysis - Date https://community.qlik.com/t5/QlikView/Set-Analysis-Date/m-p/1140901#M893888 <HTML><HEAD></HEAD><BODY><P>Just provide Date format to your expression</P><P></P><P><STRONG>=Sum({&lt;SalesDate={"$(=date(Max(SalesDate)-2,'DD-MM-YYYY'))"}&gt;}Sales)</STRONG></P></BODY></HTML> Sat, 06 Aug 2016 05:51:48 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-Date/m-p/1140901#M893888 Kushal_Chawda 2016-08-06T05:51:48Z Re: Set Analysis - Date https://community.qlik.com/t5/QlikView/Set-Analysis-Date/m-p/1140902#M893889 <HTML><HEAD></HEAD><BODY><P>Kushal</P><P></P><P>Thanks! Works perfectly.</P><P></P><P>Shamit</P></BODY></HTML> Sat, 06 Aug 2016 06:04:56 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-Date/m-p/1140902#M893889 shamitshah 2016-08-06T06:04:56Z