topic Expression Week and Year in QlikView https://community.qlik.com/t5/QlikView/Expression-Week-and-Year/m-p/346491#M492877 <HTML><HEAD></HEAD><BODY><P> i will show the sell of the last week the expression show the last sell of this week i can't find it what is wrong</P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code"><STRONG style="color: #ff8000; font-size: 8pt; text-decoration: underline;"> </STRONG><SPAN style="color: #0000ff; font-size: 8pt;"><SPAN style="color: #0000ff; font-size: 8pt;"><P>sum</P></SPAN><P></P></SPAN><P><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;">) </SPAN></P><SPAN style="font-size: 8pt;"> </SPAN><P></P></PRE></BODY></HTML> Mon, 11 Jun 2012 11:34:49 GMT 2012-06-11T11:34:49Z Expression Week and Year https://community.qlik.com/t5/QlikView/Expression-Week-and-Year/m-p/346491#M492877 <HTML><HEAD></HEAD><BODY><P> i will show the sell of the last week the expression show the last sell of this week i can't find it what is wrong</P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code"><STRONG style="color: #ff8000; font-size: 8pt; text-decoration: underline;"> </STRONG><SPAN style="color: #0000ff; font-size: 8pt;"><SPAN style="color: #0000ff; font-size: 8pt;"><P>sum</P></SPAN><P></P></SPAN><P><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;">) </SPAN></P><SPAN style="font-size: 8pt;"> </SPAN><P></P></PRE></BODY></HTML> Mon, 11 Jun 2012 11:34:49 GMT https://community.qlik.com/t5/QlikView/Expression-Week-and-Year/m-p/346491#M492877 2012-06-11T11:34:49Z