topic Re: Firstsortedvalue in QlikView

Firstsortedvalue

Anonymous — Wed, 20 Sep 2017 06:33:55 GMT

=FirstSortedValue( Aggr(Concat(DISTINCT EmployeeID, ','),YearlyIncome),-Aggr(YearlyIncome,YearlyIncome))

how to write this expression in script level

Re: Firstsortedvalue

Anil_Babu_Samineni — Wed, 20 Sep 2017 07:25:01 GMT

May be this?

Table:

Load EmploeeID,

YearlyIncome FROM Table;

NoConcatenate

Table1:

Load Concat(EmployeeID, ',') as EmployeeID, YearIncome Resident Table Group By YearIncome;

Left Join (Table1)

Load EmployeeID, YearIncome, FirstSortedValue(EmployeeID, -YearIncome) as FirstValue Resident Table1 Group By YearIncome;

Drop Table Table;

Re: Firstsortedvalue

tresB — Wed, 20 Sep 2017 07:30:04 GMT

May be like:

t1:

load

Concat(DISTINCT EmployeeID, ',') as NewField

From <> Group BY YearlyIncome;

t2:

Load

FirstSortedValue(NewField,-YearlyIncome) as NewFinal

resident t1 ; //Group By YearlyIncome;

Re: Firstsortedvalue

Anonymous — Wed, 20 Sep 2017 09:46:35 GMT

it's not working

Re: Firstsortedvalue

tresB — Wed, 20 Sep 2017 09:52:51 GMT

Ashok chowdary wrote:

it's not working

'not working' and yet you mark it as 'correct'. Both can't be right. If you have marked it by mistake, you can unmark it so that you keep getting attention of people want to help. If 'working', you can edit and remove 'not' to remove confusion.

And if 'not working' is the actual status, please explain what,how.. it is not working. Perhaps a sample data set and expected output could help us better understand and better help you in turn.

Re: Firstsortedvalue

Anil_Babu_Samineni — Wed, 20 Sep 2017 09:54:35 GMT

Then why you mark it as Correct answer. Does this useful or not atlast. Not sure, Your intend here. Perhaps provide more details with same data set that may demonstrates the output..

Re: Firstsortedvalue

Anonymous — Wed, 20 Sep 2017 10:08:01 GMT

Invalid expression

left join(Temp)

Load newone, Date, FirstSortedValue(newone,-Date) as FirstValue Resident Temp Group By Date

Re: Firstsortedvalue

Anil_Babu_Samineni — Wed, 20 Sep 2017 10:53:51 GMT

Can you provide sample data