Discussion board where members can learn more about Qlik Sense App Development and Usage.
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
Go to Solution.
Have you tried using a where condition in the load script?
WHERE Status <> "X"
It worked with where [status] <> ('X');
Thanks a lot.