topic FirstSortedValue Function in QlikView

FirstSortedValue Function

Fri, 13 Nov 2009 02:15:04 GMT

I have a group of records with an unique Id, and a repetead Ticket_Id, so for one TicketId could be more than one records.

I am trying to load the last value of this group of records order by the unique Id:

The Field1 or Field2 could have a null value, i must load it anyway.

LOAD FirstSortedValue(Ticket_Id, -Id) as Ticket_Id, Field1, Field2

FROM ..\example.qvd (qvd);

This is not working, it's loading the records that don't have null in Field1 or Field2, and with a repetead Ticket_Id. I want to load only the record wich have the last Id of the group, so, the Ticket_Id won't be repeated.

Is this the correct function to do this? It's a problem with the parameters??

FirstSortedValue Function

Fri, 13 Nov 2009 02:26:58 GMT

LOAD FirstSortedValue(Ticket_Id, -Id) as Ticket_Id, Field1

FROM ..\example.qvd (qvd)

GROUP BY Field1;

this is the correct syntax for the query

FirstSortedValue Function

Anonymous — Fri, 13 Nov 2009 02:42:41 GMT

LOAD Ticket_Id, FirstSortedValue(Field1, -Id) as Field1

FROM ..\example.qvd (qvd)

GROUP BY Ticket_Id;