Get value to max date

Question

I have a problem on on Qlikview. I would like to get the associated value of the max date when I select and ID. For example, if I have the following data:

id value date
1    2    1
1    4    2
1    6    3
1    5    4

When I select ID=1 I would like to get the associated value of the max date (4), which is 5 Thank you!

and what database? does it support analytical functions which would make this easy? — xQbert, Oct 25 '17 at 14:41
Can't find anything on that database. maybe stefan has you covered with set analysis in Qlik — xQbert, Oct 25 '17 at 18:03

score 1 · Answer 1 · answered Oct 25 '17 at 16:04

1

You can use set analysis to achieve this:

= Sum( {< date = {"$(=Max(date))"} >} value )

You can read more about set analysis on Qlik Help website

answered Oct 25 '17 at 16:04

Stefan Stoichev

4,615
3
31
51

Get value to max date

1 Answers1