Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
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