Error in function Max

[guyvermeiren]

Hello,

I want to trace only the row with the highest value but I get an Error (.... in calculated dimension).

The expression I use for the calculated dimension is:

=Max(num([Opportunity-Quote.Revision]))

Further on I only want to keep the record with this maximum value in my table, somethong like:

= If( Max(num([Opportunity-Quote.Revision] <>num([Opportunity-Quote.Revision]);Max(num([Opportunity-Quote.Revision];null())

Or is there another way to obtain this ??

Thanks

Kind regards,

Guy

[krishnacbe]

Hi,

Try with below script.

TableName:
Load max(DateCreated) as MaxDate
Resident [TableName];

Let vMaxDate=Peek(MaxDate,0,TableName);

[krishnacbe]

You can replace DateCreated with your date field and compare the variable value in Set Analysis or If statement.

[#4]

check the function: firstsortedvalue()

https://community.qlik.com/thread/30532

Hope this helps.

Thanks,

Singh