topic Re: Simple Load Where In.... in QlikView

Simple Load Where In....

prees959 — Mon, 13 Aug 2018 15:40:36 GMT

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 — Mon, 13 Aug 2018 15:46:45 GMT

Try like:

LOAD *

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

SQL

Select * from [Table A];

neelamsaroha157 — Mon, 13 Aug 2018 15:46:48 GMT

Load *

from

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

;