topic FirstSortedValue(Distinct) syntax error in expression in QlikView https://community.qlik.com/t5/QlikView/FirstSortedValue-Distinct-syntax-error-in-expression/m-p/1430953#M808655 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>=FirstSortedValue(Distinct PaxName,-aggr(Sum([Invoice Value]),Function, PaxName),1)</P><P></P><P>can any one suggest why this error is showing</P><P></P><P>Thanks</P><P>Rajesh</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT Rajesh 2020-11-25T16:16:04Z FirstSortedValue(Distinct) syntax error in expression https://community.qlik.com/t5/QlikView/FirstSortedValue-Distinct-syntax-error-in-expression/m-p/1430953#M808655 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>=FirstSortedValue(Distinct PaxName,-aggr(Sum([Invoice Value]),Function, PaxName),1)</P><P></P><P>can any one suggest why this error is showing</P><P></P><P>Thanks</P><P>Rajesh</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/FirstSortedValue-Distinct-syntax-error-in-expression/m-p/1430953#M808655 Rajesh 2020-11-25T16:16:04Z Re: FirstSortedValue(Distinct) syntax error in expression https://community.qlik.com/t5/QlikView/FirstSortedValue-Distinct-syntax-error-in-expression/m-p/1430954#M808656 <HTML><HEAD></HEAD><BODY><P>Could you please share what error you are getting ?</P></BODY></HTML> Wed, 25 Oct 2017 12:17:33 GMT https://community.qlik.com/t5/QlikView/FirstSortedValue-Distinct-syntax-error-in-expression/m-p/1430954#M808656 prma7799 2017-10-25T12:17:33Z Re: FirstSortedValue(Distinct) syntax error in expression https://community.qlik.com/t5/QlikView/FirstSortedValue-Distinct-syntax-error-in-expression/m-p/1430955#M808657 <HTML><HEAD></HEAD><BODY><P>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.</P></BODY></HTML> Wed, 25 Oct 2017 12:21:18 GMT https://community.qlik.com/t5/QlikView/FirstSortedValue-Distinct-syntax-error-in-expression/m-p/1430955#M808657 tresB 2017-10-25T12:21:18Z Re: FirstSortedValue(Distinct) syntax error in expression https://community.qlik.com/t5/QlikView/FirstSortedValue-Distinct-syntax-error-in-expression/m-p/1430956#M808658 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>value is coming perfect but its showing syntax error..</P></BODY></HTML> Wed, 25 Oct 2017 12:23:53 GMT https://community.qlik.com/t5/QlikView/FirstSortedValue-Distinct-syntax-error-in-expression/m-p/1430956#M808658 Rajesh 2017-10-25T12:23:53Z