Discussion board where members can get started with Qlik Sense.
we have users who need to load data via the DataManager without scripting. That works fine, but the filter capabilities that create a "where(...)" clause in the locked script seems problematic.
How can we exclude rows with a specific string in a data field? Specifically we want to exclude "-" in the field ID from being loaded. Usually, I would use something like
load * from xyz where(ID<>'-')
Unfortunately the DataManager offers only <, >, =, >= and <= but not <> as criteria.
Any ideas to do this without editing the script?