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

Announcements
Share your agentic AI experience, learn from others, and earn a new badge: Put Agentic AI to Work
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) 

Labels (1)
1 Reply
swuehl
Champion III
Champion III

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

Maybe your condition is always true?