Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
alsellaro
Contributor III
Contributor III

How to avoid loading data according to the value of a field?

Hello

I need to load data on a Table chart ignoring any record that has a specific value for one of the fields. Is there an elegant way of doing it?

The field name is Status. I want to load and display all records on the Table chart, except for records whose Status = "X".

It seems a rather basic question, but I didn't manage to find an answer anywhere.
Thanks

1 Solution

Accepted Solutions
rachel_delany
Creator
Creator

Have you tried using a where condition in the load script?

E.g.

LOAD *

FROM data

WHERE Status <> "X"

View solution in original post

2 Replies
rachel_delany
Creator
Creator

Have you tried using a where condition in the load script?

E.g.

LOAD *

FROM data

WHERE Status <> "X"

View solution in original post

alsellaro
Contributor III
Contributor III
Author

It worked with where [status] <> ('X');

Thanks a lot.