SQL Query

[#1]

Hi,

What is the similar query in Qlikview for the SQL statement :

Select * From table where date in (x,y,z);

Regards

[#2 · Accepted solution]

There is a example when  vLocals='x','y','z', but you can use explicits condicion

IF not wildmatch( $(vLocals),'')  and not wildmatch( $(vDates),'') then

Cabs:

          NoConcatenate

          LOAD

          *

          FROM

          $(vQVD_File)

          (qvd)

          WHERE (  (wildmatch( Codi_local, $(vLocales) )  and  Match(Fech_docum, '05/05/2013','05/06/2013') )

          ;

Regards,

Santiago.

[IAMDV]

HI Vijit,

You need to use something like this...either Match() or WildMatch() functions.

LOAD * FROM TABLE.QVD (qvd)

WHERE match(CODE, 'a', 'b', 'f');

I've also made a video tutorial on my blog. Here is the link :

http://qlikshare.com/292

I hope this helps!

Cheers,

DV

www.QlikShare.com

[alexandros17]

... where wildmatch(date,x,y,z);

[#5]

Thanks all.