Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.


Apply "exclude" filter on a string using DataManager


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?


Labels (4)