topic set analisys in QlikView https://community.qlik.com/t5/QlikView/set-analisys/m-p/459694#M1166160 <HTML><HEAD></HEAD><BODY><P>Dear all,</P><P>I'm using the following expression, but I aim to know how it works. Let me add more detail: in my intention,</P><P>I would sum all the purchase values till August (MY_MONTH) or other selected month</P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_1351373594316259" jivemacro_uid="_1351373594316259"><P>aggr(sum({&lt;PURCH_MONTH={"&lt;= $(=only(MY_MONTH))"}&gt;} PURCHASE_VALUE),MY_YEAR, MY_SUPPLIER)</P></PRE><P></P><P>It seems correct, because I get the required values.</P><P>Now, I need to&nbsp; calculate another value but for PURCH_MONTH &lt; MY_MONTH.</P><P>I was convinced that I could do it changing the condition&nbsp; &lt;PURCH_MONTH= {" &lt; $(=only(MY_MONTH))......</P><P>but it doesn't work.</P><P></P><P>Does anyone know what I'm doing wrong ?</P><P></P><P>Thanks in advance</P><P>stefan</P></BODY></HTML> Sat, 27 Oct 2012 21:40:16 GMT Anonymous 2012-10-27T21:40:16Z set analisys https://community.qlik.com/t5/QlikView/set-analisys/m-p/459694#M1166160 <HTML><HEAD></HEAD><BODY><P>Dear all,</P><P>I'm using the following expression, but I aim to know how it works. Let me add more detail: in my intention,</P><P>I would sum all the purchase values till August (MY_MONTH) or other selected month</P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_1351373594316259" jivemacro_uid="_1351373594316259"><P>aggr(sum({&lt;PURCH_MONTH={"&lt;= $(=only(MY_MONTH))"}&gt;} PURCHASE_VALUE),MY_YEAR, MY_SUPPLIER)</P></PRE><P></P><P>It seems correct, because I get the required values.</P><P>Now, I need to&nbsp; calculate another value but for PURCH_MONTH &lt; MY_MONTH.</P><P>I was convinced that I could do it changing the condition&nbsp; &lt;PURCH_MONTH= {" &lt; $(=only(MY_MONTH))......</P><P>but it doesn't work.</P><P></P><P>Does anyone know what I'm doing wrong ?</P><P></P><P>Thanks in advance</P><P>stefan</P></BODY></HTML> Sat, 27 Oct 2012 21:40:16 GMT https://community.qlik.com/t5/QlikView/set-analisys/m-p/459694#M1166160 Anonymous 2012-10-27T21:40:16Z