Simple Load Where In....

[prees959]

Hi,

Can anyone give me the easiest way to  do the following SQL like statement in Qlikview:

Select * from [Table A] where value123 in ('Blue',' Black','Red','Orange','Purple','Green','Violet','Cyan','Magenta','Lime')

Many thanks,

Phil

[vishsaggi]

Try like:

LOAD *

WHERE Match(value123, 'Blue',' Black','Red','Orange','Purple','Green','Violet','Cyan','Magenta','Lime')>0;

SQL

Select * from [Table A];

[neelamsaroha157 · Accepted solution]

Load *

from

[Table A] where Match(value123, 'Blue',' Black','Red','Orange','Purple','Green','Violet','Cyan','Magenta','Lime')

;