topic Variable in set analysis expression in QlikView https://community.qlik.com/t5/QlikView/Variable-in-set-analysis-expression/m-p/210089#M64831 <HTML><HEAD></HEAD><BODY><P>I expect this to work:</P><P>sum({$&lt;[Cost Category]={'Net sales'}, MonthYear={<STRONG>'Jan-$(LastSalesYear)'</STRONG>}&gt;} (1+VAT)*[Monthly amount]/[ActExchRate])</P></BODY></HTML> Mon, 20 Sep 2010 20:37:37 GMT Anonymous 2010-09-20T20:37:37Z Variable in set analysis expression https://community.qlik.com/t5/QlikView/Variable-in-set-analysis-expression/m-p/210088#M64830 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Anyone have an idea why this expression does not work? LastSalesYear standing for last year is variable and this couses problem.</P><P></P><P>sum({$&lt;[Cost Category]={'Net sales'}, <STRONG>MonthYear={'Jan-' &amp; LastSalesYear</STRONG>}&gt;} (1+VAT)*[Monthly amount]/[ActExchRate])</P><P></P><P></P><P></P><BR /><BR /> <P></P><P></P><P></P></BODY></HTML> Mon, 20 Sep 2010 20:17:44 GMT https://community.qlik.com/t5/QlikView/Variable-in-set-analysis-expression/m-p/210088#M64830 2010-09-20T20:17:44Z Variable in set analysis expression https://community.qlik.com/t5/QlikView/Variable-in-set-analysis-expression/m-p/210089#M64831 <HTML><HEAD></HEAD><BODY><P>I expect this to work:</P><P>sum({$&lt;[Cost Category]={'Net sales'}, MonthYear={<STRONG>'Jan-$(LastSalesYear)'</STRONG>}&gt;} (1+VAT)*[Monthly amount]/[ActExchRate])</P></BODY></HTML> Mon, 20 Sep 2010 20:37:37 GMT https://community.qlik.com/t5/QlikView/Variable-in-set-analysis-expression/m-p/210089#M64831 Anonymous 2010-09-20T20:37:37Z Variable in set analysis expression https://community.qlik.com/t5/QlikView/Variable-in-set-analysis-expression/m-p/210090#M64832 <HTML><HEAD></HEAD><BODY><P>Works perfectly.</P><P>Thanks Michael</P></BODY></HTML> Mon, 20 Sep 2010 20:42:56 GMT https://community.qlik.com/t5/QlikView/Variable-in-set-analysis-expression/m-p/210090#M64832 2010-09-20T20:42:56Z