How to implement SQL server in () using Qlikview?

[fionna51]

Hi

I just have a simple question. When I select in SQL server, I may use:

select *

from table a

where a. someID in (1,2,3,4)

How to do it in Qlikview?

And, when I LOAD following, how to do the IF better?

LOAD if (ID = 1 or ID =2 or ID =3 or ID =4 or ID =5, 'special', ID)  AS newID      

Resident tableB;

[petter · Accepted solution]

You can write this:

Match( someID , 1,2,3,4 )

You can use this both in a LOAD statement in a WHERE-clause and in the field/column part of a load.

So the last could be writen:

LOAD

     If( Match( ID , 1 , 2 , 3 , 4 , 5 ) , 'special' , ID ) AS newID

RESIDENT

     tableB;

[fionna51]

Thanks a lot.