Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
jhlovenc
Contributor

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

1 Solution

Accepted Solutions
jhlovenc
Contributor

Re: Load Where Match

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

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

1 Reply
jhlovenc
Contributor

Re: Load Where Match

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

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

Community Browser