topic YerMonth - 100 in QlikView https://community.qlik.com/t5/QlikView/YerMonth-100/m-p/170860#M41108 <HTML><HEAD></HEAD><BODY><P>Up....</P></BODY></HTML> Mon, 31 May 2010 12:46:22 GMT 2010-05-31T12:46:22Z YerMonth - 100 https://community.qlik.com/t5/QlikView/YerMonth-100/m-p/170857#M41105 <HTML><HEAD></HEAD><BODY><P>Hi Everybody:)</P><P>I've got problem with period YearMonth - 100 (Year-1)</P><P>In the selection user can choice YearMonth wchich aren't countinous period. For exmaple: 200903, 200906, 201011</P><P>I want to evaluate:</P><P>Sales for this period - no problem - in expression I don't use any YeraMonth</P><P>Sales for this period - 1 Year - I don't know how</P><P>If this period is continous - no problem</P><P></P><PRE ___default_attr="plain" class="jive_text_macro jive_macro_code" jivemacro="code"><BR /><BR />YearMonth={"&gt;=$(=((Left(Min(YearMonth), 4)-1)&amp;(Right(Min(YearMonth),2))))"}*{"&lt;=$(=((Left(Max(YearMonth), 4)-1)&amp;(Right(Max(YearMonth),2))))"<BR /></PRE><BR /><BR /> <P>but what if isn't countinous....????</P><P></P></BODY></HTML> Mon, 31 May 2010 07:35:09 GMT https://community.qlik.com/t5/QlikView/YerMonth-100/m-p/170857#M41105 2010-05-31T07:35:09Z YerMonth - 100 https://community.qlik.com/t5/QlikView/YerMonth-100/m-p/170858#M41106 <HTML><HEAD></HEAD><BODY><P>Try this</P><P>sum( {$&lt; X= { "&gt;=201001 &lt;=201003","&gt;=201007 &lt;=201011" } &gt;} X)</P></BODY></HTML> Mon, 31 May 2010 07:50:10 GMT https://community.qlik.com/t5/QlikView/YerMonth-100/m-p/170858#M41106 2010-05-31T07:50:10Z YerMonth - 100 https://community.qlik.com/t5/QlikView/YerMonth-100/m-p/170859#M41107 <HTML><HEAD></HEAD><BODY><P>I can't point in expression cocrete YearMonth. This point users in current selections</P></BODY></HTML> Mon, 31 May 2010 08:12:54 GMT https://community.qlik.com/t5/QlikView/YerMonth-100/m-p/170859#M41107 2010-05-31T08:12:54Z YerMonth - 100 https://community.qlik.com/t5/QlikView/YerMonth-100/m-p/170860#M41108 <HTML><HEAD></HEAD><BODY><P>Up....</P></BODY></HTML> Mon, 31 May 2010 12:46:22 GMT https://community.qlik.com/t5/QlikView/YerMonth-100/m-p/170860#M41108 2010-05-31T12:46:22Z YerMonth - 100 https://community.qlik.com/t5/QlikView/YerMonth-100/m-p/170861#M41109 <HTML><HEAD></HEAD><BODY><P>Hi Magda,</P><P>please see the attached example (the lower part) for more help.</P><P>Good luck!</P><P>Rainer</P></BODY></HTML> Mon, 31 May 2010 14:18:39 GMT https://community.qlik.com/t5/QlikView/YerMonth-100/m-p/170861#M41109 2010-05-31T14:18:39Z