FirstSortedValue(Distinct) syntax error in expression

[Rajesh]

Hi All,

=FirstSortedValue(Distinct PaxName,-aggr(Sum([Invoice Value]),Function, PaxName),1)

can any one suggest why this error is showing

Thanks

Rajesh

[prma7799]

Could you please share what error you are getting ?

[tresesco · Accepted solution]

You are probably using not very latest version of qv. Using 'Distinct ' in the firstsortedvalue() would throw error (red highlighting). It was a bug in old qlik parser. You could ignore the error and go ahead. The expression works fine.

[Rajesh]

Hi

value is coming perfect but its showing syntax error..