topic Re: Max function on straight table in QlikView

Max function on straight table

Tue, 10 Feb 2015 11:49:00 GMT

Hi,

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.

Thanks

tresB — Tue, 10 Feb 2015 11:57:04 GMT

Straight table:

Dimension: User

Exp1: Max(Id)

Exp2: FirstSortedValue([Number of Sites], -Id)

Exp3: FirstSortedValue(Remaining, -Id)

Exp4: FirstSortedValue(Used, -Id)

Tue, 10 Feb 2015 12:19:13 GMT

Hi Ashley,

Please give contract as dimension and give the above expressions.

PFA

Warm Regards,

Joshmi

rubenmarin — Tue, 10 Feb 2015 12:23:33 GMT

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".