Load with Order By and undefined values

Thu, 26 Jun 2014 11:26:25 GMT

Hi,

I have problem loading data from resident table when I need first value for the group and there are undefined values in group. When data is sorted in UI, undefined values go to the end of list, but looks like it's not a case for load. I've tried 2 different statements:

LOAD [%Job ID],

FirstValue([Task Planner]) as [Job Task Planner]

Resident Tasks

GROUP BY [%Job ID]

ORDER BY [%Job ID] ASC,[Task Planned At] ASC;

and

LOAD [%Job ID],

FirstSortedValue([Task Planner],[Task Planned At]) as [Job Task Planner]

Resident Tasks

GROUP BY [%Job ID];

In both cases if there is row with undefined [Task Planner],[Task Planned At], I get undefined result. Even if there are rows with values in a group.

topic Load with Order By and undefined values in QlikView

Load with Order By and undefined values