topic Re: SQL where Question. in QlikView

SQL where Question.

MuraliPrasath — Tue, 26 Apr 2016 07:57:28 GMT

Hi,

I need to restrict

where YEAR = 2015 and 2016.

how to do this in qlikview.

Tue, 26 Apr 2016 08:02:15 GMT

You can add it in script almost like SQL.

LOAD *

FROM

YourQVDHere.qvd

(qvd)

where(year = ('2015') or year = ('2016'));

Gysbert_Wassenaar — Tue, 26 Apr 2016 08:22:30 GMT

Where do you want to restrict this? In a chart or with loading the data?

Anil_Babu_Samineni — Tue, 26 Apr 2016 08:30:56 GMT

Niklas. Might be he want, 2015 and 2016 data..

Tue, 26 Apr 2016 08:43:37 GMT

SELECT *

FROM table

WHERE YEAR IN (2015, 2016);

Kushal_Chawda — Tue, 26 Apr 2016 08:51:58 GMT

If you want to restrict it while loading the data from database then do it like below

Data:

SQL SELECT *

FROM Tablename

where YEARFIELD IN ('2015','2016');

STORE Data into path\Tablename.QVD;

DROP TABLE Data;

if you want to restrict this in Qlikview script

Data:

LOAD *

FROM Tablename.QVD(QVD)

WHERE match(YEARFIELD,'2015','2016');

If you want to restrict at chart level use the below expression

=sum({<YEAR ={'2015','2016'}>Value)

MuraliPrasath — Tue, 26 Apr 2016 09:16:02 GMT

WHERE match(YEARFIELD,'2015','2016');

This is worked. thanks Kishal.