topic Really URGENT How to do firstsorted value in Load script in QlikView

Really URGENT How to do firstsorted value in Load script

Thu, 14 Nov 2013 14:40:27 GMT

here is my load script

tablea:

Load

account,

From ....

tableb:

Load

expiry-date,

id,

effective-date

From ....

How do I get

Account - Maximum(expiry-date), firstsortedvalue(distinct id, -expiry-date), firstsortedvalue(distinct effective-date, -expiry-date)

In new table.

Please Help.

Re: Really URGENT How to do firstsorted value in Load script

swuehl — Thu, 14 Nov 2013 15:27:40 GMT

You can try joining your two tables, then do a resident load with a group by clause for the aggregations:

tablea:

Load

account,

INLINE [

account, id

a, 10

b, 20

];

tableb:

JOIN (tablea) Load

[expiry-date],

id,

[effective-date]

INLINE [

expiry-date, id, effective-date

10,10,20

10,10,30

20,20,10

30,20,10

];

LOAD account,

firstvalue([expiry-date]),

firstvalue(id),

firstvalue([effective-date])

Resident tablea GROUP BY account order by account, [expiry-date] desc;

Re: Really URGENT How to do firstsorted value in Load script

Thu, 14 Nov 2013 15:41:10 GMT

field not found on last last load

Re: Re: Really URGENT How to do firstsorted value in Load script

swuehl — Thu, 14 Nov 2013 15:43:46 GMT

which field not found?

works for me.

Re: Really URGENT How to do firstsorted value in Load script

Thu, 14 Nov 2013 15:58:57 GMT

There are gods in world. You are one of them. Thank you so much ❤️