Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
rvijayanth
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
shraddha_g
Honored Contributor III

Re: Selecting certain records while LOADing in QlikSense

Try:

Load

Color as "System Color"

Quantity

From  "File"

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

2 Replies
shraddha_g
Honored Contributor III

Re: Selecting certain records while LOADing in QlikSense

Try:

Load

Color as "System Color"

Quantity

From  "File"

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

rvijayanth
Contributor

Re: Selecting certain records while LOADing in QlikSense

Thank you so much