Discussion Board for collaboration related to QlikView App Development.
I'm really struggling with the following and would appreciate some help.
I have a simple table with the following Info in:
What I need is a summary table which will show all of the information, but only for the highest quote number. So in the following fields:
So for example, here's the data:
load * inline [
and I need the output to look like this:
I've tried using the aggr(), Max() and FirstSortedValue() - which works for the Qty and value but as soon as I drop in the Version Field I get a list of all the versions.
Check the attached
View solution in original post
Sunny, as always you've got the perfect answer!