topic get latest value in QlikView https://community.qlik.com/t5/QlikView/get-latest-value/m-p/231595#M83312 <HTML><HEAD></HEAD><BODY><P>[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/0383.exemplo.zip:550:0]</P><P>look the example!!! i think is your doubt!!!!</P></BODY></HTML> Thu, 07 Oct 2010 20:14:46 GMT 2010-10-07T20:14:46Z get latest value https://community.qlik.com/t5/QlikView/get-latest-value/m-p/231593#M83310 <HTML><HEAD></HEAD><BODY><P>I need to get the latest product (I have to get only those whose value is different from 'null')</P><P></P><P>example:</P><P>A____950___12/03/09</P><P>A____null___19/04/10</P><P>A____320___01/08/10</P><P>B____250___10/02/09</P><P>B____100___24/12/09</P><P>B____null___30/06/10</P><P><BR /></P><P>in this case would be:</P><P>A____320___01/08/10</P><P>B____100___24/12/09</P><P></P><P>What can I put in the 'name', 'value', 'date'?<BR /></P></BODY></HTML> Thu, 07 Oct 2010 19:04:11 GMT https://community.qlik.com/t5/QlikView/get-latest-value/m-p/231593#M83310 2010-10-07T19:04:11Z get latest value https://community.qlik.com/t5/QlikView/get-latest-value/m-p/231594#M83311 <HTML><HEAD></HEAD><BODY><P>You can put on chart, dimension product.....and your expression use a MAX(date)....</P><P></P></BODY></HTML> Thu, 07 Oct 2010 20:02:25 GMT https://community.qlik.com/t5/QlikView/get-latest-value/m-p/231594#M83311 2010-10-07T20:02:25Z get latest value https://community.qlik.com/t5/QlikView/get-latest-value/m-p/231595#M83312 <HTML><HEAD></HEAD><BODY><P>[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/0383.exemplo.zip:550:0]</P><P>look the example!!! i think is your doubt!!!!</P></BODY></HTML> Thu, 07 Oct 2010 20:14:46 GMT https://community.qlik.com/t5/QlikView/get-latest-value/m-p/231595#M83312 2010-10-07T20:14:46Z get latest value https://community.qlik.com/t5/QlikView/get-latest-value/m-p/231596#M83313 <HTML><HEAD></HEAD><BODY><P>this case if the latest date has a null value, he'll get this null value ... but I do not want to appear nulls</P></BODY></HTML> Thu, 07 Oct 2010 20:16:23 GMT https://community.qlik.com/t5/QlikView/get-latest-value/m-p/231596#M83313 2010-10-07T20:16:23Z get latest value https://community.qlik.com/t5/QlikView/get-latest-value/m-p/231597#M83314 <HTML><HEAD></HEAD><BODY><P>Did you check this?</P><P>I tested on my application.....max function don´t take a null value if you have one field with value!!!!</P><P></P></BODY></HTML> Thu, 07 Oct 2010 20:46:43 GMT https://community.qlik.com/t5/QlikView/get-latest-value/m-p/231597#M83314 2010-10-07T20:46:43Z