Discussion Board for collaboration related to QlikView App Development.
I'm attempting to use the max function as an expression to return the highest id but the expression always seems to return null for each record.
For example: these 3 users have the same data on each contract but 789 is the most recent so this is the only record I need.
User and Id are dimensions and the others are expressions.
So what I would need is for the table to look like this:
Does anyone know how to achieve this? Any help is much appreciated.
Go to Solution.
Exp2: FirstSortedValue([Number of Sites], -Id)
Exp3: FirstSortedValue(Remaining, -Id)
Exp4: FirstSortedValue(Used, -Id)
View solution in original post
Please give contract as dimension and give the above expressions.
Hi Ashley, another option can be change Id dimension to a calculated dimension like:
=Aggr(If(Id=Max(TOTAL Id), Id), Id)
Checking "Supress when value is null".