topic expression problem in QlikView https://community.qlik.com/t5/QlikView/expression-problem/m-p/347605#M492855 <HTML><HEAD></HEAD><BODY><P>Use only one set expression, set modifier separated by comma:</P><P></P><P><CODE class="jive-code">sum<BR />({$&lt;jaar={$(=max(jaar)-1)}, week={$(=max(week))}&gt;}[Aantal geleverd]) </CODE></P></BODY></HTML> Mon, 11 Jun 2012 21:11:06 GMT swuehl 2012-06-11T21:11:06Z expression problem https://community.qlik.com/t5/QlikView/expression-problem/m-p/347604#M492854 <HTML><HEAD></HEAD><BODY><DIV> hello, please help me with a stupid problem, i will see the same week this year en <SPAN class="wordentry" id="word1">previous</SPAN> year.</DIV><DIV><DIV>this expression dosn't work the table show the last week this year .</DIV></DIV><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code"><SPAN style="color: #0000ff; font-size: 8pt;"><SPAN style="color: #0000ff; font-size: 8pt;"><DIV>sum</DIV></SPAN><DIV> </DIV></SPAN><DIV><SPAN style="font-size: 8pt;">({$&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">jaar</SPAN><SPAN style="font-size: 8pt;">={</SPAN><STRONG><EM style=": ; color: #808080; font-size: 8pt;">$(=max(jaar)-1)</EM></STRONG><EM style=": ; color: #808080; font-size: 8pt;"> </EM><SPAN style="color: #808080; font-size: 8pt;"> </SPAN><SPAN style="font-size: 8pt;">}&gt;}{$&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">week</SPAN><SPAN style="font-size: 8pt;">={</SPAN><STRONG><EM style=": ; color: #808080; font-size: 8pt;">$(=max(week))</EM></STRONG><EM style=": ; color: #808080; font-size: 8pt;"> </EM><SPAN style="color: #808080; font-size: 8pt;"> </SPAN><SPAN style="font-size: 8pt;">}&gt;}</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Aantal geleverd]</SPAN><SPAN style="font-size: 8pt;">)&nbsp; </SPAN></DIV><DIV><SPAN style="font-size: 8pt;"> </SPAN></DIV></PRE><DIV> </DIV></BODY></HTML> Mon, 11 Jun 2012 21:09:22 GMT https://community.qlik.com/t5/QlikView/expression-problem/m-p/347604#M492854 2012-06-11T21:09:22Z expression problem https://community.qlik.com/t5/QlikView/expression-problem/m-p/347605#M492855 <HTML><HEAD></HEAD><BODY><P>Use only one set expression, set modifier separated by comma:</P><P></P><P><CODE class="jive-code">sum<BR />({$&lt;jaar={$(=max(jaar)-1)}, week={$(=max(week))}&gt;}[Aantal geleverd]) </CODE></P></BODY></HTML> Mon, 11 Jun 2012 21:11:06 GMT https://community.qlik.com/t5/QlikView/expression-problem/m-p/347605#M492855 swuehl 2012-06-11T21:11:06Z expression problem https://community.qlik.com/t5/QlikView/expression-problem/m-p/347606#M492856 <HTML><HEAD></HEAD><BODY><P> Thanx it works !!!</P></BODY></HTML> Mon, 11 Jun 2012 21:15:11 GMT https://community.qlik.com/t5/QlikView/expression-problem/m-p/347606#M492856 2012-06-11T21:15:11Z