Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
dmpilars
Partner - Creator
Partner - Creator

FILTER option in DATA MANAGER

Hello,

Today I have the following question, I need to apply a multiple filter to a table through the option of filtering in the data manager. For certain business reasons I cannot do it from the data script. What is the correct way to include multiple possible values ​​for a data field, for example: Id = 111, AA2,333,444,555,666,888,BB7. I tried generating a binary field that marked me with 0 field values ​​that I don't want to include but I found that the filtering option only recognizes original fields from the table load and not those created directly.

 

POSTQLIK.png

 FIELD: Id (in my real dataset this field should contain numbers and letters)

CONDITION: =

VALUE: 111,AAA2,333,444,555,666,BB7,888 (What is the correct form to write this in the value option? )

 

Thanks!!!!!!!

Labels (2)
2 Replies
Anil_Babu_Samineni

Perhaps this?

'111','AAA2','333','444','555','666','BB7','888'

Or

(111 | AAA2 | 333 | 444 | 555 | 666 | BB7 | 888)

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
dmpilars
Partner - Creator
Partner - Creator
Author

Hello!!!

not works :c; 

I had already tried this:'111', 'AAA2', '333', '444', '555', '666', 'BB7', '888 '