Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Channa
Specialist III
Specialist III

Latest Status Based on Date

Hi i need to get latest record based on data from below table

Channa_0-1670293986179.png

i use this expression but not working i still see 4 record but i need to see only latest step

FirstSortedValue( [StepStatus.ProcessInstanceStep],[CreatedDate.ProcessInstanceStep])

need to get only record with max date "9/1/2022 3:09:44 PM"

please find attach for sample data need to see only one record for "ProcessNodeName"

Channa
Labels (3)
2 Replies
MayilVahanan

Hi

If you have CreatedDate.ProcessInstanceStep as dimension, then for each value, it generates the output.

Remove the field as dimension and verify once

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Channa
Specialist III
Specialist III
Author

thank you for responding @MayilVahanan  it still the same, it shows all 4 records

 

for legal i need to show only one record

after removing data i still see all record

Channa_0-1670476361129.png

 

 

Channa