topic Re: Max function in Time in QlikView https://community.qlik.com/t5/QlikView/Max-function-in-Time/m-p/94857#M757175 <HTML><HEAD></HEAD><BODY><P>Thanks Marcus. Your answer is clear.</P></BODY></HTML> Fri, 21 Sep 2018 11:06:40 GMT Anonymous 2018-09-21T11:06:40Z Max function in Time https://community.qlik.com/t5/QlikView/Max-function-in-Time/m-p/94855#M757173 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10pt;">As a beginner, I would like to understand</SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><PRE __default_attr="sql" __jive_macro_name="code" class="jive_macro_code _jivemacro_uid_15374951778213567 jive_text_macro" jivemacro_uid="_15374951778213567"> <P>Sum({&lt;Year=, Month=, Quarter=, Week=, DateField=, DateNum={"&gt;=$(=Num(YearStart(<STRONG>Max</STRONG>(DateNum))))&lt;=$(=<STRONG>Max</STRONG>(DateNum))"}&gt;} Sales)</P> </PRE><P></P><P>but not</P><P></P><PRE __default_attr="sql" __jive_macro_name="code" class="jive_macro_code jive_text_macro _jivemacro_uid_15374951691402065" jivemacro_uid="_15374951691402065"> <P>Sum({&lt;Year=, Month=, Quarter=, Week=, DateField=, DateNum={"&gt;=$(=Num(YearStart(DateNum)))&lt;=$(=DateNum)"}&gt;} Sales)</P> </PRE><P></P><P>My understanding is the expression will take the value of selected Date, thus result is the same. Why is MAX function&nbsp; needed here? Any implication if I use the 2nd expression?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Max-function-in-Time/m-p/94855#M757173 Anonymous 2020-11-25T16:16:04Z Re: Max function in Time https://community.qlik.com/t5/QlikView/Max-function-in-Time/m-p/94856#M757174 <HTML><HEAD></HEAD><BODY><P>Referring to a field returns only a value if there is only a unique fieldvalue available - otherwise the result is NULL. Therefore the suggestion to use always aggregations, see: <A href="https://community.qlik.com/qlik-blogpost/3779">Use Aggregation Functions!</A></P><P></P><P>- Marcus</P></BODY></HTML> Fri, 21 Sep 2018 06:43:16 GMT https://community.qlik.com/t5/QlikView/Max-function-in-Time/m-p/94856#M757174 marcus_sommer 2018-09-21T06:43:16Z Re: Max function in Time https://community.qlik.com/t5/QlikView/Max-function-in-Time/m-p/94857#M757175 <HTML><HEAD></HEAD><BODY><P>Thanks Marcus. Your answer is clear.</P></BODY></HTML> Fri, 21 Sep 2018 11:06:40 GMT https://community.qlik.com/t5/QlikView/Max-function-in-Time/m-p/94857#M757175 Anonymous 2018-09-21T11:06:40Z