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: 
Anonymous
Not applicable

Get data with lowest Date

I'm trying to find out how to display the lowest value for a specific date to display in a textbox but haven't found anything that is working.

Show ItemId that has the lowest ImportDate. I have been trying out som Set-Analys but can I only use them together with some kind of aggregating function but I only want to show just the value(ItemId) with the lowest ImportDate.

/Frank

1 Solution

Accepted Solutions
sunny_talwar

May be try with FirstSortedValue...

FirstSortedValue(DISTINCT ItemId, ImportDate)

View solution in original post

2 Replies
sunny_talwar

May be try with FirstSortedValue...

FirstSortedValue(DISTINCT ItemId, ImportDate)

Anonymous
Not applicable
Author

Thanks that worked, I'll try it out and see if the result is what I wnt.