get latest value

[#1]

I need to get the latest product (I have to get only those whose value is different from 'null')

example:

A____950___12/03/09

A____null___19/04/10

A____320___01/08/10

B____250___10/02/09

B____100___24/12/09

B____null___30/06/10

in this case would be:

A____320___01/08/10

B____100___24/12/09

What can I put in the 'name', 'value', 'date'?

[#2]

You can put on chart, dimension product.....and your expression use a MAX(date)....

[#3]

[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/0383.exemplo.zip:550:0]

look the example!!! i think is your doubt!!!!

[#4]

this case if the latest date has a null value, he'll get this null value ... but I do not want to appear nulls

[#5]

Did you check this?

I tested on my application.....max function don´t take a null value if you have one field with value!!!!