Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
cbaqir
Specialist
Specialist

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

1 Solution

Accepted Solutions
Clever_Anjos
Employee
Employee

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

View solution in original post

3 Replies
Clever_Anjos
Employee
Employee

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

View solution in original post

qlikrajan
Creator III
Creator III

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

cbaqir
Specialist
Specialist
Author

Thanks!