topic max i.s.o. sum in set analysis in QlikView https://community.qlik.com/t5/QlikView/max-i-s-o-sum-in-set-analysis/m-p/982443#M467247 <HTML><HEAD></HEAD><BODY><P>In a straight tabel I have the field INVOICEDATE as the dimension.</P><P>In the expression I have max({1} INVOICEDATE)</P><P></P><P>I would expect always the highest date in the expression but is showing the dimension date.</P><P>When I create a textbox with =<SPAN style="font-size: 13.3333px;">max({1} INVOICEDATE) it is showing the highest date, even when putting a filter on INVOICEDATE.</SPAN></P><P>What am I doing wrong?</P></BODY></HTML> Wed, 25 Nov 2015 11:12:51 GMT hansrokers 2015-11-25T11:12:51Z max i.s.o. sum in set analysis https://community.qlik.com/t5/QlikView/max-i-s-o-sum-in-set-analysis/m-p/982443#M467247 <HTML><HEAD></HEAD><BODY><P>In a straight tabel I have the field INVOICEDATE as the dimension.</P><P>In the expression I have max({1} INVOICEDATE)</P><P></P><P>I would expect always the highest date in the expression but is showing the dimension date.</P><P>When I create a textbox with =<SPAN style="font-size: 13.3333px;">max({1} INVOICEDATE) it is showing the highest date, even when putting a filter on INVOICEDATE.</SPAN></P><P>What am I doing wrong?</P></BODY></HTML> Wed, 25 Nov 2015 11:12:51 GMT https://community.qlik.com/t5/QlikView/max-i-s-o-sum-in-set-analysis/m-p/982443#M467247 hansrokers 2015-11-25T11:12:51Z Re: max i.s.o. sum in set analysis https://community.qlik.com/t5/QlikView/max-i-s-o-sum-in-set-analysis/m-p/982444#M467248 <HTML><HEAD></HEAD><BODY><P>Try: <SPAN style="font-size: 13.3333px;">max({1} TOTAL INVOICEDATE)</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">- Marcus</SPAN></P></BODY></HTML> Wed, 25 Nov 2015 11:30:33 GMT https://community.qlik.com/t5/QlikView/max-i-s-o-sum-in-set-analysis/m-p/982444#M467248 marcus_sommer 2015-11-25T11:30:33Z Re: max i.s.o. sum in set analysis https://community.qlik.com/t5/QlikView/max-i-s-o-sum-in-set-analysis/m-p/982445#M467249 <HTML><HEAD></HEAD><BODY><P>You need to calculate your expression in total context:</P><P></P><P>=Max({1} TOTAL INVOICEDATE)</P></BODY></HTML> Wed, 25 Nov 2015 11:30:52 GMT https://community.qlik.com/t5/QlikView/max-i-s-o-sum-in-set-analysis/m-p/982445#M467249 swuehl 2015-11-25T11:30:52Z Re: max i.s.o. sum in set analysis https://community.qlik.com/t5/QlikView/max-i-s-o-sum-in-set-analysis/m-p/982446#M467250 <HTML><HEAD></HEAD><BODY><P>Try:</P><P><SPAN style="font-size: 13.33px;">max( <STRONG>Total</STRONG> {1} INVOICEDATE)</SPAN></P></BODY></HTML> Wed, 25 Nov 2015 11:31:49 GMT https://community.qlik.com/t5/QlikView/max-i-s-o-sum-in-set-analysis/m-p/982446#M467250 tresB 2015-11-25T11:31:49Z