Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
tomhovens
Contributor II
Contributor II

Problem with firstsortedvalue

Hey All,

I'm looking for the first date with the max occupancy. The table with the input is;

ItemnrDateOccupancy
A1-1-2016200
A2-1-2016220
A3-1-2016220
A4-1-2016200
A5-1-2016180
B1-1-2016150
B2-1-2016175
B3-1-2016180
B4-1-2016180
B5-1-2016170

What I'm looking for is

ItemnrDateOccupancy
A2-1-2016220
B3-1-2016180

Function does work for itemnr with only 1 date with the max occupancy. Function so far is;

Firstsortedvalue(Date,-Aggr(sum(Occupancy),Date)

10 Replies
Anonymous
Not applicable

Hi Sunny,

          In the above expression, I couldn't understand the below part alone

     Date/1E6