Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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.
gregoryt40
New Contributor

Load certain data using WHERE criteria

Hello,


I am trying to load only data where the following criteria is met:

Where[Prem Category Description]='SINGLES' AND [MI Sub Status Type]='CA'

Where do I put this statement in the load script?  I am having trouble getting it to work.


Thank you!

1 Solution

Accepted Solutions

Re: Load certain data using WHERE criteria

After the from or resident table

LOAD FieldName

From YourDataSource

Where [Prem Category Description] = 'SINGLES' and [MI Sub Status Type] = 'CA';

1 Reply

Re: Load certain data using WHERE criteria

After the from or resident table

LOAD FieldName

From YourDataSource

Where [Prem Category Description] = 'SINGLES' and [MI Sub Status Type] = 'CA';

Community Browser