Discussion Board for collaboration on QlikView Scripting.
I am wondering if it is possible to use Lookup() in an if statement. Below you can see an example:
Doel as A
(ooxml, embedded labels, table is C);
Para1 AS P1,
Art As Art1,
If(Para1='B1',lookup('Doel','Para1',Para1,'Bron1'),'A') AS Doel
(ooxml, embedded labels, table is A);
See the attached file and the result.
Go to Solution.
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.
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!