Discussion Board for collaboration related to QlikView App Development.
I have a raw database table like the below, where there are excess number of rows which I want to filter out:
For trade_id=67, I want to sum only the row where msg_date_time is maximum. How can I do this in charts and text boxes?
I converted your diatomite to timestamp, ordered your table and used new Id to use FirstSortedValue.
The expression is
View solution in original post
Try to use firstsortedvalue().
Thanks Sergey, how exactly would you go about it?
I tried something like this but it doesn't work:
put -trade_id it gives max values