Help on formula

danialier · ‎2014-02-27

I'm getting an error with the following formula. Can you please help ?

=if(Region=(or('Americas','NA')),rgb(45,150,255),rgb(135,137,139))

thks,dani

alexandros17 · ‎2014-02-27

=if(Region='Americas' or Region ='NA',rgb(45,150,255),rgb(135,137,139))

aveeeeeee7en · ‎2014-02-27

Hi Dani

Try this:

=if(WildMatch(Region,'Americas',NA'),rgb(45,150,255),rgb(135,137,139))

PrashantSangle · ‎2014-02-27

Hi,

check reply given by

Alessandro Saccone

It should work fine.

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Related Topics