topic Re: Where Clause in QVD Load in QlikView

Where Clause in QVD Load

cbaqir — Thu, 10 Sep 2015 16:20:01 GMT

I saw something similar to this but not quite the same so I am asking for some help... I need to exclude two values in a field from my QVD load... but this is not working

LOAD "TASK_ID",
"TASK_NAME",
"TASK_STATUS",
"TASK_SEQ",
date([TASK_SCHED_START_DATE], 'MM/DD/YYYY') as TRX_DATE,
"TASK_SCHED_END_DATE" as TASK_START_DATE,
"TASK_SCHED_END_DATE" as TASK_END_DATE,
"TASK_SCHED_LAST_UPDATE_DATE" as TASK_LAST_UPDATED_DATE;
SQL SELECT *
FROM [..\QVD\01_Extract_QVD\DM_STAT_TASK.QVD]
(qvd)
where [TASK_STATUS] <> ('Cancelled') and [TASK_STATUS] <> ('Completed');

What am I doing wrong in my Where clause? It works when it's not loading from the QVD.

Thanks,

Cassandra

Re: Where Clause in QVD Load

Clever_Anjos — Thu, 10 Sep 2015 16:34:08 GMT

Because you don´t need to "SELECT" from a QVD

This would be enough:

FROM [..\QVD\01_Extract_QVD\DM_STAT_TASK.QVD] (qvd)

where [TASK_STATUS] <> ('Cancelled') and [TASK_STATUS] <> ('Completed');

Re: Where Clause in QVD Load

Anonymous — Thu, 10 Sep 2015 16:39:08 GMT

you dont need select statement in order to load from qvd. I have attached app and sample data. Please check.

Re: Where Clause in QVD Load

cbaqir — Thu, 10 Sep 2015 16:43:21 GMT

Thanks!