Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Insider - Maximize your investment, Join this webinar, May 26th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
JoseGarcia
Creator
Creator

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])

View solution in original post

JoseGarcia
Creator
Creator
Author

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