Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
An issue has been identified on Qlik Cloud hub, please visit our Status Update Page for details: GET THE LATEST
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Excluding when Loading

Hi Qlik Gurus,

I need help once again. I am trying to load a table and exclude a few items. However, I keep getting an error. Load works perfectly fine without my Where statement. Please advise how I can fix it.

MappingTable:

Mapping

LOAD * INLINE [

Assessment Status, Grouped Status

Complete, Draft Report Delivered

Planning, In Planning

In Progress, In Progress

Pending Business Response, In Progress

Pending Response from Business, In Progress

Pending Vendor Response, In Progress

Pending VRM Response, In Progress

Retired/Other,

Cancelled,

];

LOAD

[Assessment Status],

      ApplyMap('MappingTable', [Assessment Status]) as [Grouped Status]

FROM

(ooxml, embedded labels, table is [VRM Program Status]

WHERE not Match([Assessment Type],'Cancelled', 'Retired/Other');

ERROR Message

Capture.PNG

1 Solution

Accepted Solutions
swuehl
MVP
MVP

I still believe it's just a small typo.

Could you post a screenshot of your current LOAD statement and another one of the error message?

View solution in original post

4 Replies
swuehl
MVP
MVP

I think you are missing a closing parenthesis:

FROM

(ooxml, embedded labels, table is [VRM Program Status] )

Not applicable
Author

still the same error message

swuehl
MVP
MVP

I still believe it's just a small typo.

Could you post a screenshot of your current LOAD statement and another one of the error message?

Not applicable
Author

Yes, it was a typo! Thank you! All works now!