Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

cbaqirdhds
Contributor II

Where Clause in QVD Load

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

Tags (5)
1 Solution

Accepted Solutions
Employee
Employee

Re: Where Clause in QVD Load

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

This would be enough:

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

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

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

3 Replies
Employee
Employee

Re: Where Clause in QVD Load

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

This would be enough:

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

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

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

qlikrajan
Contributor III

Re: Where Clause in QVD Load

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

cbaqirdhds
Contributor II

Re: Where Clause in QVD Load

Thanks!

Community Browser