Qlik Community

Qlik Sense App Development

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

alsellaro
New 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
Contributor

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

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

E.g.

LOAD *

FROM data

WHERE Status <> "X"

2 Replies
rachel_delany
Contributor

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

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

E.g.

LOAD *

FROM data

WHERE Status <> "X"

alsellaro
New Contributor III

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

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

Thanks a lot.

Community Browser