topic Re: MonthStart(Max(Date)) behaves differently in dollar expansion and normal expression in App Development https://community.qlik.com/t5/App-Development/MonthStart-Max-Date-behaves-differently-in-dollar-expansion-and/m-p/1320702#M28515 <HTML><HEAD></HEAD><BODY><P>How about Try $(=Num(MonthStart(Max(Date))))??</P></BODY></HTML> Fri, 14 Apr 2017 12:52:37 GMT Anonymous 2017-04-14T12:52:37Z MonthStart(Max(Date)) behaves differently in dollar expansion and normal expression https://community.qlik.com/t5/App-Development/MonthStart-Max-Date-behaves-differently-in-dollar-expansion-and/m-p/1320701#M28514 <HTML><HEAD></HEAD><BODY><P>When I use MonthStart(Max(Date)) as an expression I get expected result</P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/160105_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P><P></P><P>However when I use it in a dollar expansion I get a weird result </P><P></P><P><IMG alt="" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/160106_pastedImage_1.png" style="max-width: 1200px; max-height: 900px;" /></P><P></P><P>I have selected "Date" for number formatting </P><P><IMG alt="" class="jive-image image-3" src="https://community.qlik.com/legacyfs/online/160107_pastedImage_3.png" style="max-width: 1200px; max-height: 900px;" /></P><P></P><P>Any help would be appreciated</P><P></P><P>Thanks &amp; Best Regards</P><P>Vikraant </P></BODY></HTML> Sat, 16 Nov 2024 09:54:47 GMT https://community.qlik.com/t5/App-Development/MonthStart-Max-Date-behaves-differently-in-dollar-expansion-and/m-p/1320701#M28514 vikraant 2024-11-16T09:54:47Z Re: MonthStart(Max(Date)) behaves differently in dollar expansion and normal expression https://community.qlik.com/t5/App-Development/MonthStart-Max-Date-behaves-differently-in-dollar-expansion-and/m-p/1320702#M28515 <HTML><HEAD></HEAD><BODY><P>How about Try $(=Num(MonthStart(Max(Date))))??</P></BODY></HTML> Fri, 14 Apr 2017 12:52:37 GMT https://community.qlik.com/t5/App-Development/MonthStart-Max-Date-behaves-differently-in-dollar-expansion-and/m-p/1320702#M28515 Anonymous 2017-04-14T12:52:37Z