topic set analysis for previous day in QlikView https://community.qlik.com/t5/QlikView/set-analysis-for-previous-day/m-p/299984#M1198747 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>the set analysis expression for the selected date in my chart is Sum({$&lt;Date=P({$} tDate )&gt;} Sales) , its working fine, I want another column with previous date to compare the sales.</P><P>Thanks in Advance...</P></BODY></HTML> Fri, 14 Jan 2011 12:05:38 GMT 2011-01-14T12:05:38Z set analysis for previous day https://community.qlik.com/t5/QlikView/set-analysis-for-previous-day/m-p/299984#M1198747 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>the set analysis expression for the selected date in my chart is Sum({$&lt;Date=P({$} tDate )&gt;} Sales) , its working fine, I want another column with previous date to compare the sales.</P><P>Thanks in Advance...</P></BODY></HTML> Fri, 14 Jan 2011 12:05:38 GMT https://community.qlik.com/t5/QlikView/set-analysis-for-previous-day/m-p/299984#M1198747 2011-01-14T12:05:38Z set analysis for previous day https://community.qlik.com/t5/QlikView/set-analysis-for-previous-day/m-p/299985#M1198748 <HTML><HEAD></HEAD><BODY><P>hi,</P><P>Create DateNum field at script level.</P><P>eg: Num(Date) as DateNum,</P><P>and Use the below expression</P><P></P><P>Sum({&lt;DateNum={$(=(Max(DateNum)-1))}&gt;} Sales)</P><P></P><P></P><P></P></BODY></HTML> Fri, 14 Jan 2011 12:38:55 GMT https://community.qlik.com/t5/QlikView/set-analysis-for-previous-day/m-p/299985#M1198748 deepakk 2011-01-14T12:38:55Z set analysis for previous day https://community.qlik.com/t5/QlikView/set-analysis-for-previous-day/m-p/299986#M1198749 <HTML><HEAD></HEAD><BODY><P>Thanks</P></BODY></HTML> Fri, 14 Jan 2011 20:05:58 GMT https://community.qlik.com/t5/QlikView/set-analysis-for-previous-day/m-p/299986#M1198749 2011-01-14T20:05:58Z