topic How to select certain selection in qvd? in QlikView

How to select certain selection in qvd?

ainrosmadi — Sat, 16 Nov 2024 18:59:22 GMT

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?

Re: How to select certain selection in qvd?

rwunderlich — Fri, 06 Mar 2020 02:47:12 GMT

...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

Re: How to select certain selection in qvd?

nikitadeshwal — Fri, 06 Mar 2020 05:05:33 GMT

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);