topic Display x Months from Selected Month? in QlikView https://community.qlik.com/t5/QlikView/Display-x-Months-from-Selected-Month/m-p/312572#M115428 <HTML><HEAD></HEAD><BODY><P>Any suggestions?&nbsp; I’ve searched on rolling month here, and see a lot of answers about how to use it in a calculated expression, but nothing quite like I want to do.&nbsp; I'm sure there's got to be a simple solution to this but I haven't been able to work it out.</P><P></P><P>I have a month field, which is a list box on my sheet.&nbsp; When a user selects a month, I want all of my charts with month as a dimension to show the selected month and the 5 months prior.</P><P></P><P>Ex:&nbsp; Selecting 2011/05, should cause my charts to show:</P><P></P><P>Month&nbsp;&nbsp;&nbsp; Expression Value</P><P>2010/12&nbsp; 5</P><P>2011/01&nbsp; 7</P><P>2011/02&nbsp; 6</P><P>2011/03&nbsp; 6.5</P><P>2011/04&nbsp; 7</P><P>2011/05&nbsp; 4</P><P></P><P>I’m attaching a sample QVD.&nbsp; Any help with this would be much appreciated!</P></BODY></HTML> Wed, 27 Jul 2011 21:25:46 GMT 2011-07-27T21:25:46Z Display x Months from Selected Month? https://community.qlik.com/t5/QlikView/Display-x-Months-from-Selected-Month/m-p/312572#M115428 <HTML><HEAD></HEAD><BODY><P>Any suggestions?&nbsp; I’ve searched on rolling month here, and see a lot of answers about how to use it in a calculated expression, but nothing quite like I want to do.&nbsp; I'm sure there's got to be a simple solution to this but I haven't been able to work it out.</P><P></P><P>I have a month field, which is a list box on my sheet.&nbsp; When a user selects a month, I want all of my charts with month as a dimension to show the selected month and the 5 months prior.</P><P></P><P>Ex:&nbsp; Selecting 2011/05, should cause my charts to show:</P><P></P><P>Month&nbsp;&nbsp;&nbsp; Expression Value</P><P>2010/12&nbsp; 5</P><P>2011/01&nbsp; 7</P><P>2011/02&nbsp; 6</P><P>2011/03&nbsp; 6.5</P><P>2011/04&nbsp; 7</P><P>2011/05&nbsp; 4</P><P></P><P>I’m attaching a sample QVD.&nbsp; Any help with this would be much appreciated!</P></BODY></HTML> Wed, 27 Jul 2011 21:25:46 GMT https://community.qlik.com/t5/QlikView/Display-x-Months-from-Selected-Month/m-p/312572#M115428 2011-07-27T21:25:46Z Re: Display x Months from Selected Month? https://community.qlik.com/t5/QlikView/Display-x-Months-from-Selected-Month/m-p/312573#M115429 <HTML><HEAD></HEAD><BODY><P>This would be helpful!</P><P>I use variable to do this.</P></BODY></HTML> Thu, 28 Jul 2011 03:13:38 GMT https://community.qlik.com/t5/QlikView/Display-x-Months-from-Selected-Month/m-p/312573#M115429 2011-07-28T03:13:38Z Re: Display x Months from Selected Month? https://community.qlik.com/t5/QlikView/Display-x-Months-from-Selected-Month/m-p/312574#M115430 <HTML><HEAD></HEAD><BODY><P> This worked for what I need - thanks!</P></BODY></HTML> Fri, 29 Jul 2011 14:16:34 GMT https://community.qlik.com/t5/QlikView/Display-x-Months-from-Selected-Month/m-p/312574#M115430 2011-07-29T14:16:34Z