topic Re: SQL Query in QlikView

SQL Query

Fri, 05 Jul 2013 15:35:56 GMT

Hi,

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

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

Regards

Fri, 05 Jul 2013 15:49:08 GMT

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 — Fri, 05 Jul 2013 15:50:05 GMT

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 :

I hope this helps!

Cheers,

alexandros17 — Fri, 05 Jul 2013 15:50:28 GMT

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

Fri, 05 Jul 2013 16:26:21 GMT

Thanks all.