topic Rolling 12 Month: a problem.... in QlikView https://community.qlik.com/t5/QlikView/Rolling-12-Month-a-problem/m-p/414244#M154096 <HTML><HEAD></HEAD><BODY><P>&nbsp; Hi all,</P><P>I found the attached file in the community. </P><P>It is an example well done and very useful</P><P>In the sheet "Sheet2" if I select a value from Region do not change the values in the table.</P><P>How can I do for the selection also to the Region dimension?</P><P></P><P> Thank </P></BODY></HTML> Tue, 30 Apr 2013 13:34:37 GMT 2013-04-30T13:34:37Z Rolling 12 Month: a problem.... https://community.qlik.com/t5/QlikView/Rolling-12-Month-a-problem/m-p/414244#M154096 <HTML><HEAD></HEAD><BODY><P>&nbsp; Hi all,</P><P>I found the attached file in the community. </P><P>It is an example well done and very useful</P><P>In the sheet "Sheet2" if I select a value from Region do not change the values in the table.</P><P>How can I do for the selection also to the Region dimension?</P><P></P><P> Thank </P></BODY></HTML> Tue, 30 Apr 2013 13:34:37 GMT https://community.qlik.com/t5/QlikView/Rolling-12-Month-a-problem/m-p/414244#M154096 2013-04-30T13:34:37Z Re: Rolling 12 Month: a problem.... https://community.qlik.com/t5/QlikView/Rolling-12-Month-a-problem/m-p/414245#M154097 <HTML><HEAD></HEAD><BODY><P>The expressions start with sum({1&lt;OrderDate={. The 1 means ignore all selections. Remove the 1 and the selection of a Region will be reflected in the calculation.</P></BODY></HTML> Tue, 30 Apr 2013 13:46:26 GMT https://community.qlik.com/t5/QlikView/Rolling-12-Month-a-problem/m-p/414245#M154097 Gysbert_Wassenaar 2013-04-30T13:46:26Z Re: Rolling 12 Month: a problem.... https://community.qlik.com/t5/QlikView/Rolling-12-Month-a-problem/m-p/414246#M154098 <HTML><HEAD></HEAD><BODY><P>OK Gysbert,</P><P>you're right.</P><P>But I would like to be able to keep the 12 months in the dimensions and also the ability to select a value for the Region</P><P></P><P> Thank</P><P>Sbuzi</P></BODY></HTML> Tue, 30 Apr 2013 13:53:07 GMT https://community.qlik.com/t5/QlikView/Rolling-12-Month-a-problem/m-p/414246#M154098 2013-04-30T13:53:07Z Re: Rolling 12 Month: a problem.... https://community.qlik.com/t5/QlikView/Rolling-12-Month-a-problem/m-p/414247#M154099 <HTML><HEAD></HEAD><BODY><P>Try sum({&lt;<STRONG>Month=, MonthYear=, </STRONG>OrderDate={"&gt;=$(=addmonths(monthend(max(OrderDate))+1,-12)) &lt;=$(=max(OrderDate))"}&gt;}Sales)</P></BODY></HTML> Sun, 05 May 2013 07:31:25 GMT https://community.qlik.com/t5/QlikView/Rolling-12-Month-a-problem/m-p/414247#M154099 Gysbert_Wassenaar 2013-05-05T07:31:25Z Re: Rolling 12 Month: a problem.... https://community.qlik.com/t5/QlikView/Rolling-12-Month-a-problem/m-p/414248#M154100 <HTML><HEAD></HEAD><BODY><P>Why do you enclose two '' - is that nessecary?</P></BODY></HTML> Sun, 05 May 2013 08:37:52 GMT https://community.qlik.com/t5/QlikView/Rolling-12-Month-a-problem/m-p/414248#M154100 2013-05-05T08:37:52Z Re: Rolling 12 Month: a problem.... https://community.qlik.com/t5/QlikView/Rolling-12-Month-a-problem/m-p/414249#M154101 <HTML><HEAD></HEAD><BODY><P>Thank you VERY MUCH</P></BODY></HTML> Fri, 07 Jun 2013 11:03:49 GMT https://community.qlik.com/t5/QlikView/Rolling-12-Month-a-problem/m-p/414249#M154101 2013-06-07T11:03:49Z