topic Re: Reg-historical month display in QlikView https://community.qlik.com/t5/QlikView/Reg-historical-month-display/m-p/913671#M316947 <HTML><HEAD></HEAD><BODY><P>Perhaps if you exclude the Period in the set analysis?</P><P></P><P>(sum({&lt;Year={$(vCurrentYear)},datasource={'DKSH','DKSH-CG','ZUELLIG-PASTEUR'},Country_Name={'Malaysia'},Invdate={"&gt;=$(=vStartDateMYBN) &lt;=$(=vDownloadDate)"}, <STRONG><EM style="color: #ff0000;">Period</EM></STRONG>&gt;}salesvalue/Rate))</P></BODY></HTML> Thu, 06 Aug 2015 13:42:56 GMT maximiliano_vel 2015-08-06T13:42:56Z Reg-historical month display https://community.qlik.com/t5/QlikView/Reg-historical-month-display/m-p/913670#M316946 <HTML><HEAD></HEAD><BODY><P>Hi Team ,</P><P>i have attached the expression please find the attached .</P><P>i have straight table report andi have filters as month.if i select current month the data is coming correct and if i select the previous month iam getting zero values for the YTD%ACH,YTD%ARCHF1 for the coloumns.Please can any one help me out<SPAN style="color: #ffffff;"> </SPAN><IMG alt="month _capture.PNG" class="jive-image image-1" src="/legacyfs/online/95196_month _capture.PNG" style="height: 202px; width: 620px;" /></P></BODY></HTML> Thu, 06 Aug 2015 10:00:16 GMT https://community.qlik.com/t5/QlikView/Reg-historical-month-display/m-p/913670#M316946 2015-08-06T10:00:16Z Re: Reg-historical month display https://community.qlik.com/t5/QlikView/Reg-historical-month-display/m-p/913671#M316947 <HTML><HEAD></HEAD><BODY><P>Perhaps if you exclude the Period in the set analysis?</P><P></P><P>(sum({&lt;Year={$(vCurrentYear)},datasource={'DKSH','DKSH-CG','ZUELLIG-PASTEUR'},Country_Name={'Malaysia'},Invdate={"&gt;=$(=vStartDateMYBN) &lt;=$(=vDownloadDate)"}, <STRONG><EM style="color: #ff0000;">Period</EM></STRONG>&gt;}salesvalue/Rate))</P></BODY></HTML> Thu, 06 Aug 2015 13:42:56 GMT https://community.qlik.com/t5/QlikView/Reg-historical-month-display/m-p/913671#M316947 maximiliano_vel 2015-08-06T13:42:56Z