topic Need Help in QlikView https://community.qlik.com/t5/QlikView/Need-Help/m-p/654926#M1065761 <HTML><HEAD></HEAD><BODY><P>How to get the expression by max(snapshot_date) ?</P><P></P><P>PFA.</P><P></P><P>The max(snapshot_date)&nbsp; is 2014-09-09 00:00:00.000 .</P><P></P><P>I want to show Current Forecast = 800</P><P>JE Forecast = 800</P><P></P><P>which is the value for the latest snapshot.</P><P></P><P>As, for Fiscal Month : JUL it is having 2 snapshot_date i.e 2014-09-09 00:00:00.000 and 2014-09-03 00:00:00.000.</P><P></P><P>Thus, now it is adding the values of both snapshot.</P><P></P><P>My requirement is to get the latest value of the max(snanshot).</P></BODY></HTML> Tue, 09 Sep 2014 11:58:29 GMT suvechha_b 2014-09-09T11:58:29Z Need Help https://community.qlik.com/t5/QlikView/Need-Help/m-p/654926#M1065761 <HTML><HEAD></HEAD><BODY><P>How to get the expression by max(snapshot_date) ?</P><P></P><P>PFA.</P><P></P><P>The max(snapshot_date)&nbsp; is 2014-09-09 00:00:00.000 .</P><P></P><P>I want to show Current Forecast = 800</P><P>JE Forecast = 800</P><P></P><P>which is the value for the latest snapshot.</P><P></P><P>As, for Fiscal Month : JUL it is having 2 snapshot_date i.e 2014-09-09 00:00:00.000 and 2014-09-03 00:00:00.000.</P><P></P><P>Thus, now it is adding the values of both snapshot.</P><P></P><P>My requirement is to get the latest value of the max(snanshot).</P></BODY></HTML> Tue, 09 Sep 2014 11:58:29 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/654926#M1065761 suvechha_b 2014-09-09T11:58:29Z Re: Need Help https://community.qlik.com/t5/QlikView/Need-Help/m-p/654927#M1065762 <HTML><HEAD></HEAD><BODY><P>=FirstSortedValue(Current_forecast,-snapshot_date)</P></BODY></HTML> Tue, 09 Sep 2014 12:07:36 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/654927#M1065762 tresB 2014-09-09T12:07:36Z Re: Re: Need Help https://community.qlik.com/t5/QlikView/Need-Help/m-p/654928#M1065763 <HTML><HEAD></HEAD><BODY><P>Yes it worked..</P><P></P><P>But I want the Total also .</P><P></P><P>PFA.</P></BODY></HTML> Tue, 09 Sep 2014 12:24:48 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/654928#M1065763 suvechha_b 2014-09-09T12:24:48Z