Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
michael_klix
Contributor

Apply "exclude" filter on a string using DataManager

Hi,

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)