Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

SQL Query

Hi,

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

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

Regards

1 Solution

Accepted Solutions
Not applicable

Re: SQL Query

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.

4 Replies
Not applicable

Re: SQL Query

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
Not applicable

Re: SQL Query

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
Not applicable

Re: SQL Query

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

Not applicable

Re: SQL Query

Thanks all.