topic Re: Load Script: Using Lookup() in an If statement in QlikView

Load Script: Using Lookup() in an If statement

Thu, 28 Feb 2013 14:12:54 GMT

Hello,

I am wondering if it is possible to use Lookup() in an if statement. Below you can see an example:

Bron1:

LOAD Para1,

Doel as A

FROM

TEST_QV.xlsx

(ooxml, embedded labels, table is C);

Fact:

LOAD Nr,

Para1 AS P1,

Art As Art1,

If(Para1='B1',lookup('Doel','Para1',Para1,'Bron1'),'A') AS Doel

FROM

TEST_QV.xlsx

(ooxml, embedded labels, table is A);

See the attached file and the result.

Re: Load Script: Using Lookup() in an If statement

Gysbert_Wassenaar — Thu, 28 Feb 2013 14:17:41 GMT

It's certainly possible. However you renamed Doel to A in your first load, so the field Doel doesn't exist, but A does. Change your lookup accordingly.

Re: Load Script: Using Lookup() in an If statement

Thu, 28 Feb 2013 14:24:35 GMT

Thanks a lot

I was expecting that he would still look at the original name, but it works now! Sometimes you're almost there but just need a 2nd person to take out the last bug!