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: 
cbaqir
Specialist II
Specialist II

Dimension If Statement

What is wrong with this statement? It says Expression OK.

I am trying to use it as one of 3 Dimensions but nothing is showing up when there should be...

=if(match(RESP_PROG_DIR,'Not Classified')>0 or match(TASK_STATUS,'Cancelled','Completed')>0,null(),RESP_PROG_DIR

1 Reply
swuehl
MVP
MVP

You expression looks fine for me, at least the syntax seems correct.

Maybe your condition is always true?