Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Sara_3
Creator
Creator

how to get reference field value ?

code post  date Line number  create  date  model
234 1/22/2020 20 7/6/2019 r
234 5/9/2019 10 2/4/2018 g
234 4/7/2020 40 1/4/2020 n
         
         

 

I selected code = 234 and it has 3 rows , I am looking for MIN value of Post Date which I will get MIN(post date ) it will be 5/9/2019 . 

Requirement: (highlighted red )

how  will I  get the values like Line number (10) and Create date (2/4/2018) of the same row MIN post date (5/9/2019)  in KPI.

2 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Sara_3
Creator
Creator
Author

Thanks Rob, I will try .