Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
brittsch1
Contributor
Contributor

Qliksense filtering data from Data Manager > File Locations

Hi, I need to use the data manager to filter data being brought into Qlik.

 

I'm trying to remove records that end in "Test"

I've tried the following 

right([Full Name],4)<>'Test'

brittsch1_1-1712605355100.png

It works as a new column, but not as a filter in the loading page for files.

I am unable to use data load editor.

Thank you!

 

Labels (1)
1 Reply
mpc
Partner Ambassador
Partner Ambassador

Hi, 

You cannot use expression nor wildcard in the filter option of the Data Manager. You'll need to use the script for your usecase. 

Regards

From Next Decision and mpc with love