Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Contributor

Selecting certain records while LOADing in QlikSense

What is the syntax for restricting rows while loading data using Data Load editor.

For example I want to load "Color" column where the values are ONLY red and green

Load

Color as "System Color"

Quantity

From  "File"

where color in ('Red', 'Green')

How to do this?

Tags (1)
1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Re: Selecting certain records while LOADing in QlikSense

Try:

Load

Color as "System Color"

Quantity

From  "File"

where wildmatch(Color,'Red','Green');

View solution in original post

2 Replies
Highlighted
Partner
Partner

Re: Selecting certain records while LOADing in QlikSense

Try:

Load

Color as "System Color"

Quantity

From  "File"

where wildmatch(Color,'Red','Green');

View solution in original post

Highlighted
Contributor

Re: Selecting certain records while LOADing in QlikSense

Thank you so much