topic Re: Another set analysis question in QlikView https://community.qlik.com/t5/QlikView/Another-set-analysis-question/m-p/251593#M1182973 <HTML><HEAD></HEAD><BODY><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code"><P>=sum({1&lt;<STRONG>QUOTA_Month</STRONG>={'$(=num(month(today())))'}&gt;}&nbsp; <STRONG>QUOTA_Quota</STRONG>)</P></PRE></BODY></HTML> Wed, 04 Jan 2012 20:50:35 GMT 2012-01-04T20:50:35Z Another set analysis question https://community.qlik.com/t5/QlikView/Another-set-analysis-question/m-p/251592#M1182972 <HTML><HEAD></HEAD><BODY><P>Hi all</P><P>This expression works correctly for me:&nbsp;&nbsp; <STRONG>=sum({1&lt;QUOTA_Month={1}&gt;}&nbsp; QUOTA_Quota).</STRONG></P><P></P><P>But when substituing in the expression </P><P><STRONG>QUOTA_Month={1}</STRONG></P><P>with </P><P><STRONG>QUOTA_Month={<SPAN style="color: #ff0000;">$(=num(month(today())))</SPAN>}</STRONG></P><P></P><P><STRONG>=sum({1&lt;QUOTA_Month={<SPAN style="color: #ff0000;">$(=num(month(today())))</SPAN>}&gt;}&nbsp; QUOTA_Quota)</STRONG> </P><P></P><P>it does not work.</P><P></P><P>Am I doing something wrong?</P><P></P><P>QUOTA_Month is numeric</P><P></P><P></P><P>Thanks</P></BODY></HTML> Wed, 04 Jan 2012 19:54:02 GMT https://community.qlik.com/t5/QlikView/Another-set-analysis-question/m-p/251592#M1182972 jduenyas 2012-01-04T19:54:02Z Re: Another set analysis question https://community.qlik.com/t5/QlikView/Another-set-analysis-question/m-p/251593#M1182973 <HTML><HEAD></HEAD><BODY><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code"><P>=sum({1&lt;<STRONG>QUOTA_Month</STRONG>={'$(=num(month(today())))'}&gt;}&nbsp; <STRONG>QUOTA_Quota</STRONG>)</P></PRE></BODY></HTML> Wed, 04 Jan 2012 20:50:35 GMT https://community.qlik.com/t5/QlikView/Another-set-analysis-question/m-p/251593#M1182973 2012-01-04T20:50:35Z Re: Another set analysis question https://community.qlik.com/t5/QlikView/Another-set-analysis-question/m-p/251594#M1182974 <HTML><HEAD></HEAD><BODY><P> Thanks you Thomas</P></BODY></HTML> Wed, 04 Jan 2012 23:57:06 GMT https://community.qlik.com/t5/QlikView/Another-set-analysis-question/m-p/251594#M1182974 jduenyas 2012-01-04T23:57:06Z