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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
YorickVDF
Contributor II
Contributor II

Quick Question about set expression filtering through IF-function

Hello everyone,

 

I am a relatively new user of Qlik Sense and I have a quick question about about set expression filtering through IF-function.

Quite often i use a IF function to filter certain columns in a table. Most of the times i use a OR-function to have multiple filters. Example:

" =IF( InstructieID ='CCPC' OR 'ADHERE_RM' OR 'ADHERE4', [Instructie Naam]) "

 

Now i am to broaden a certain table by filtering the InstructieID for any InstructionID which contains "ADHERE". Regardless of whats before or after "ADHERE". But when i use the Asterisk symbol unfortunatly the filter does not work correcttly and the table becomes empty. 

=IF( InstructieID = '*ADHERE*' , [Instructie Naam])

 

Hopefully someone is able to help me. Thanks in advance!

Labels (1)
1 Reply
YorickVDF
Contributor II
Contributor II
Author

Hello Everyone, 

I got it while searching on the world wide web. I just had to change the "IS-symbol" to "Like". Probably i posed a bit too early!

Example:

YorickVDF_0-1627907759687.png