Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
pduplessis
Partner
Partner

Where Clause in QVD load

I have an app loading incremental data daily. In the past something caused us to load a whole batch of data, and now I have discovered a problem with this load.

Fortunately, we load the file name in the initial load and save the data to a QVD.

I want to "fix" this data, first by excluding the bad data from the QVD.

I was hoping I could use something like this:

FROM

(qvd)

where FileName < > 'PO_DUMP_02-25to07-18.csv'

;

Unfortunately QV doesn't like <> for not equal on the QVD load. Could somebody help with the syntax here, I have tried a bunch of diffreent things.

Thanks

1 Solution

Accepted Solutions
Not applicable

try

FROM

(qvd)

where (not FileName = 'PO_DUMP_02-25to07-18.csv')

;

View solution in original post

2 Replies
Not applicable

try

FROM

(qvd)

where (not FileName = 'PO_DUMP_02-25to07-18.csv')

;

View solution in original post

pduplessis
Partner
Partner

Thanks, I appreciate the help.