Discussion Board for collaboration on QlikView Layout & Visualizations.
I've a little aggr issue to solve
Some people have 2 status. When there are different i can't display the last one.
Name Date Status
A 2/11/13 open
A 2/12/13 stand by
B 5/11/13 open
B 2/12/13 open
What i get is
and I'd like to get Status Stand by for A
I tried to aggregate on max(date) but it didn't work
Thank you for your help
Go to Solution.
USE STRAIGHT TABLE
Dimension = Name
Expression = FIRSTSORTEDVALUE(Status, -Date)
Did you try FirstSortedValue ?
you're all right.
I was just deep inside aggr function. I will therefore remember this one
I think you can also use it with the LOAD statement (and GROUP BY)