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!
