Discussion Board for collaboration related to Creating Analytics for QlikView.
i have an aggr expresion which retrives Status dates,
i want to retrive the min date value
tried it with:
would you be able to share with us more details on this ?
what you have so far and what is the expected output ?
i need to retrive only one row whith the min/max date
Did you try?
With the "-" before the date to get the highest value (most recent date) or without it for the opposite (oldest date)
Exp2: FirstSortedValue(Quantity, -Date)
Exp3: FirstSortedValue(Status, -Date)
For Min you could adjust.
If the Quantity and Status are always the same across all dates, then you can also use Only(Quantity) and Only(Status), but this might be only true in the sample, but just to throw out an option