Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
JoseGarcia
Creator III
Creator III

Dimension name

Hi all, 

I need to restrict my dimension to only show 2 measures.

Using this formula, but I believe I am missing the trick here. 
Could anyone assist?

=If([CC$.risk_rating]='amber',  + [CC$.risk_rating]='red', [CC$.risk_rating])

Thanks a million.

Jose

1 Solution

Accepted Solutions
tresesco
MVP
MVP

@JoseGarcia Try like:

=If([CC$.risk_rating]='amber' OR  [CC$.risk_rating]='red', [CC$.risk_rating])

View solution in original post

2 Replies
tresesco
MVP
MVP

@JoseGarcia Try like:

=If([CC$.risk_rating]='amber' OR  [CC$.risk_rating]='red', [CC$.risk_rating])

JoseGarcia
Creator III
Creator III
Author

It worked, thanks a million.
Just could not remember the OR 🙂