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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Manuel174102
Creator
Creator

List of items I want to filter out in Data Manager

Hello everyone. 

I want to filter out some items in the data manager. Those are a list of items. How could I do it at once?

I have been trying the following but it doesnt work.

where:

"Document"<>  ('17407','17384','18942',18493')

"Document"<>  ['17407','17384','18942',18493']

"Document"<>  {'17407','17384','18942',18493'}

 

thanks in advance

 

 

Labels (1)
2 Solutions

Accepted Solutions
justISO
Specialist
Specialist

Hi, probably it is easier to do it 'Data load editor' -  with match() function for this, just add WHERE clause below FROM:

Load

...

From ...

WHERE not match(Document, '17407','17384','18942',18493');

View solution in original post

Manuel174102
Creator
Creator
Author

hey, thanks for answering. 

 

when I write that formula, the "not" is highlighted in red. 

it doesnt work 😞

View solution in original post

4 Replies
justISO
Specialist
Specialist

Hi, probably it is easier to do it 'Data load editor' -  with match() function for this, just add WHERE clause below FROM:

Load

...

From ...

WHERE not match(Document, '17407','17384','18942',18493');

Manuel174102
Creator
Creator
Author

hey, thanks for answering. 

 

when I write that formula, the "not" is highlighted in red. 

it doesnt work 😞

justISO
Specialist
Specialist

does your FROM line ends with ';'? you should remove it, as WHERE clause is part of LOAD and ';' should be last of WHERE.

Manuel174102
Creator
Creator
Author

thank u!! it worked now!

 

i have another problem now hahaah 

Something weird happens with my graph. HELP PLEAS... - Qlik Community - 1985931

 

do u have a clue what is going on?