firstsortedvalue function

Tue, 21 Jun 2011 15:51:40 GMT

Hi all,

I have a data set that comprises 2 tables.

The first table is work orders, the second table is labour transactions. The relationship is one to many, linked by a WONUM key field.

I want to show the first labour transaction date for each work order in a straight table. Im trying to use the following function as one of the chart expressions:

=firstsortedvalue(LABTRANSDATE,LABTRANSDATE)

But it is returning null in all cases except where there is only a single corresponding labour record (i.e where there is a one to one relationship).

Can anyone suggest another way to do this?

Thanks

firstsortedvalue function

danielrozental — Tue, 21 Jun 2011 16:10:09 GMT

Thing is firstsortedvalue will only return results if there is a single corresponding value for the first sorte field.

If you just want to get the date you could just use Min(LABTRANSDATE).

topic firstsortedvalue function in QlikView

firstsortedvalue function

firstsortedvalue function