Where clause in table with multiple fields using LastValue()

Sun, 03 Aug 2014 22:03:07 GMT

Hallo QV geniuses,

I have s script like this:

Table1:

Load UID,

date_modified

FROM excel...;

Table2:

Load UID,

LastValue(A) as A_1,

LastValue(B) as B_1,

LastValue(C) as C_1,

LastValue(D) as D_1,

LastValue(E) as E_1,

LastValue(F) as F_1

Resident Table1

where not isNull(UID)

Group by UID

Order by date_modified;

Since it is ordered by date_modified, it means my LastValue() is the latest. But my problem is: If the LastValue() is NULL, I want to get the previous NON-NULL value.

I tried to put a:

where not isNull(UID) and not isNull(A) and not isNull(B) and not isNull(C) and not isNull(D) and not isNull(E) and not isNull(F)

But it doesn't work. Can you help me on this? Thanks a lot.

Re: Where clause in table with multiple fields using LastValue()

pablolabbe — Tue, 03 Feb 2015 13:30:26 GMT

Hi,

Did you solved it ?

topic Where clause in table with multiple fields using LastValue() in QlikView

Where clause in table with multiple fields using LastValue()

Re: Where clause in table with multiple fields using LastValue()