Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
frankrudolf
Contributor III
Contributor III

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)

frankrudolf
Contributor III
Contributor III
Author

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