How to select certain selection in qvd?

[ainrosmadi]

Hi Good Morning,

Kindly need your help

i want to select dept_code in ( 2100,2200,2300,2400,2500,2600,2700,2800,2900)  in below scripts:

D7_Department_Warehouse:

LOAD

dept_code,
dept_short,
dept_long



FROM
[C:\QspikesData\MYMOHES\PELAJAR\D7_Department_Warehouse.qvd]
(qvd);

can someone help me to solved this?

[rwunderlich · Accepted solution]

...FROM
[C:\QspikesData\MYMOHES\PELAJAR\D7_Department_Warehouse.qvd]
(qvd)
Where Match(dept_code, 2100,2200,2300,2400,2500,2600,2700,2800,2900) 
;

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

[nikitadeshwal · Accepted solution]

Try this,

LOAD
dept_code,
dept_short,
dept_long
FROM
[C:\QspikesData\MYMOHES\PELAJAR\D7_Department_Warehouse.qvd]
(qvd)Where match(dept_code,2100,2200,2300,2400,2500,2600,2700,2800,2900);