topic Error in function Max in QlikView

Error in function Max

guyvermeiren — Wed, 25 Nov 2020 16:16:04 GMT

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 — Tue, 06 Sep 2016 15:48:43 GMT

Hi,

Try with below script.

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

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

krishnacbe — Tue, 06 Sep 2016 15:50:12 GMT

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

Wed, 07 Sep 2016 15:29:34 GMT

check the function: firstsortedvalue()

Hope this helps.

Thanks,

Singh