topic Re: How to show future 13 weeks data in QlikView https://community.qlik.com/t5/QlikView/How-to-show-future-13-weeks-data/m-p/669360#M243293 <HTML><HEAD></HEAD><BODY><P>Here is the correct answer</P><P></P><P>if(GetSelectedCount(Week_No)=0 and GetSelectedCount(Month)=0 and GetSelectedCount(Quarter)=0 and Year_No=Year(Today()),</P><P>&nbsp; (((sum({$&lt;Month=,Year_No=,Week_No= {'&gt;=$(vCWeek) &lt;=$(vCWeek13)'}&gt;}sold))</P><P></P><P>vCWeek = =(week(today()))</P><P></P><P>vCWeek13 = =((week(today()))+12)</P></BODY></HTML> Tue, 07 Oct 2014 13:23:52 GMT 2014-10-07T13:23:52Z How to show future 13 weeks data https://community.qlik.com/t5/QlikView/How-to-show-future-13-weeks-data/m-p/669359#M243292 <HTML><HEAD></HEAD><BODY><P>Hello everyone,</P><P></P><P>I wanted to show future 13 weeks data what ever filter user selects. </P><P></P><P>Can anybody please help me in this.</P><P></P><P>Thanks</P></BODY></HTML> Tue, 07 Oct 2014 07:31:04 GMT https://community.qlik.com/t5/QlikView/How-to-show-future-13-weeks-data/m-p/669359#M243292 2014-10-07T07:31:04Z Re: How to show future 13 weeks data https://community.qlik.com/t5/QlikView/How-to-show-future-13-weeks-data/m-p/669360#M243293 <HTML><HEAD></HEAD><BODY><P>Here is the correct answer</P><P></P><P>if(GetSelectedCount(Week_No)=0 and GetSelectedCount(Month)=0 and GetSelectedCount(Quarter)=0 and Year_No=Year(Today()),</P><P>&nbsp; (((sum({$&lt;Month=,Year_No=,Week_No= {'&gt;=$(vCWeek) &lt;=$(vCWeek13)'}&gt;}sold))</P><P></P><P>vCWeek = =(week(today()))</P><P></P><P>vCWeek13 = =((week(today()))+12)</P></BODY></HTML> Tue, 07 Oct 2014 13:23:52 GMT https://community.qlik.com/t5/QlikView/How-to-show-future-13-weeks-data/m-p/669360#M243293 2014-10-07T13:23:52Z