topic Re: Find Max date of 2 fields in QlikView https://community.qlik.com/t5/QlikView/Find-Max-date-of-2-fields/m-p/778544#M275973 <HTML><HEAD></HEAD><BODY><P>Try this</P><P>=RangeMax(Cal_dim_expr1,Cal_dim_expr12)</P></BODY></HTML> Tue, 13 Jan 2015 07:25:05 GMT anbu1984 2015-01-13T07:25:05Z Find Max date of 2 fields https://community.qlik.com/t5/QlikView/Find-Max-date-of-2-fields/m-p/778543#M275972 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>i need to find Max Date with expression comparing of 2 field but both these fields are Calculated dimensions. </P><P><IMG class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/75168_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P><P></P><P>Thankyou </P></BODY></HTML> Tue, 13 Jan 2015 07:14:45 GMT https://community.qlik.com/t5/QlikView/Find-Max-date-of-2-fields/m-p/778543#M275972 2015-01-13T07:14:45Z Re: Find Max date of 2 fields https://community.qlik.com/t5/QlikView/Find-Max-date-of-2-fields/m-p/778544#M275973 <HTML><HEAD></HEAD><BODY><P>Try this</P><P>=RangeMax(Cal_dim_expr1,Cal_dim_expr12)</P></BODY></HTML> Tue, 13 Jan 2015 07:25:05 GMT https://community.qlik.com/t5/QlikView/Find-Max-date-of-2-fields/m-p/778544#M275973 anbu1984 2015-01-13T07:25:05Z Re: Find Max date of 2 fields https://community.qlik.com/t5/QlikView/Find-Max-date-of-2-fields/m-p/778545#M275974 <HTML><HEAD></HEAD><BODY><P>Dear,</P><P></P><P>can you check the below example.</P><P></P><P>Load * Inline</P><P>[</P><P>Forecast1,Event1</P><P>10/18/2012,05/08/2012</P><P>09/06/2012,05/14/2012</P><P>09/28/2012,07/25/2012</P><P>10/25/2012,08/22/2012</P><P>10/10/2012,11/11/2012</P><P>]</P><P>;</P><P>Dimensions</P><P>Forecast1</P><P>Event1</P><P>Expression:</P><P>=if(Num(Forecast1)&gt;Num(Event1),Forecast1,Event1)</P><P></P><P><IMG alt="" class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/75175_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P><P>But as you mentioned you have calculated dimension . so try to use the calculated Dimension syntax in the expression.</P><P>else attach the sample file for better understanding.</P><P></P><P>Thanks,</P><P>Mukram</P></BODY></HTML> Tue, 13 Jan 2015 07:31:13 GMT https://community.qlik.com/t5/QlikView/Find-Max-date-of-2-fields/m-p/778545#M275974 mdmukramali 2015-01-13T07:31:13Z Re: Find Max date of 2 fields https://community.qlik.com/t5/QlikView/Find-Max-date-of-2-fields/m-p/778546#M275975 <HTML><HEAD></HEAD><BODY><P>Thank you <STRONG style="font-size: 11.6999998092651px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><A href="https://community.qlik.com/people/anbu1984">anbu1984</A>,</STRONG> <STRONG style="font-size: 11.6999998092651px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><A href="https://community.qlik.com/people/MDMUKRAMALI">MDMUKRAMALI</A></STRONG></P><P></P></BODY></HTML> Tue, 13 Jan 2015 08:46:19 GMT https://community.qlik.com/t5/QlikView/Find-Max-date-of-2-fields/m-p/778546#M275975 2015-01-13T08:46:19Z