Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Load Where Match

I have looked through the forums and found the advice on how to load specific (Or exclude specific as the case may be) records from a qvd and it seems very simple, but i cannot get it to work - I get the error listed below the example.  What am I missing?

Sites:

Load *  FROM $(vQVDPathRepository)$(vQVDRepositoryFilePrefix)SVMXC_Site.qvd (qvd) 

Where Match (SVMXC_Site_Movex_Id, 

10313_905_2,

10461_003_2,

10585_003_2,

11572_003_2,

11572_004_2,

11604_001_2,

17661_001_2,

18100_004_2) ; 

Error in expression: ')' expected

Labels (1)
1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

I figured it out, single quotes '10313_905_2' required,

and ...')>0; required at end

View solution in original post

1 Reply
Anonymous
Not applicable
Author

I figured it out, single quotes '10313_905_2' required,

and ...')>0; required at end