Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
michael_klix
Creator II
Creator II

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 (2)
0 Replies