topic Re: Help on formula in QlikView https://community.qlik.com/t5/QlikView/Help-on-formula/m-p/580296#M1116184 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">=</SPAN><SPAN style="font-size: 10pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 10pt; font-family: inherit; color: #0000ff;">if</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 10pt; font-family: inherit;">(</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 10pt; font-family: inherit; color: #800000;">Region</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 10pt; font-family: inherit;">=</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 10pt; font-family: inherit;">'Americas' or Region ='NA',rgb(45,150,255),rgb(135,137,139))</SPAN></SPAN></P></BODY></HTML> Thu, 27 Feb 2014 16:22:45 GMT alexandros17 2014-02-27T16:22:45Z Help on formula https://community.qlik.com/t5/QlikView/Help-on-formula/m-p/580295#M1116183 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10pt;">I'm getting an error with the following formula. Can you please help ?&nbsp; </SPAN></P><P> </P><P>=<SPAN style="font-size: 10pt;"><SPAN style="color: #0000ff; font-size: 10pt;">if</SPAN><SPAN style="font-size: 10pt;">(</SPAN><SPAN style="color: #800000; font-size: 10pt;">Region</SPAN><SPAN style="font-size: 10pt;">=(</SPAN><SPAN style="color: #0000ff; font-size: 10pt;">or</SPAN><SPAN style="font-size: 10pt;">('Americas','NA')),rgb(45,150,255),rgb(135,137,139)) </SPAN></SPAN></P><P> </P><P><SPAN style="font-size: 10pt;">thks,dani</SPAN></P></BODY></HTML> Thu, 27 Feb 2014 16:20:36 GMT https://community.qlik.com/t5/QlikView/Help-on-formula/m-p/580295#M1116183 danialier 2014-02-27T16:20:36Z Re: Help on formula https://community.qlik.com/t5/QlikView/Help-on-formula/m-p/580296#M1116184 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">=</SPAN><SPAN style="font-size: 10pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 10pt; font-family: inherit; color: #0000ff;">if</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 10pt; font-family: inherit;">(</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 10pt; font-family: inherit; color: #800000;">Region</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 10pt; font-family: inherit;">=</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 10pt; font-family: inherit;">'Americas' or Region ='NA',rgb(45,150,255),rgb(135,137,139))</SPAN></SPAN></P></BODY></HTML> Thu, 27 Feb 2014 16:22:45 GMT https://community.qlik.com/t5/QlikView/Help-on-formula/m-p/580296#M1116184 alexandros17 2014-02-27T16:22:45Z Re: Help on formula https://community.qlik.com/t5/QlikView/Help-on-formula/m-p/580297#M1116185 <HTML><HEAD></HEAD><BODY><P>Hi Dani</P><P></P><P>Try this:</P><P></P><P><SPAN style="font-size: 10pt;">=if(WildMatch(<SPAN style="color: #800000; font-size: 10pt;">Region</SPAN>,<SPAN style="font-size: 10pt;">'Americas',<SPAN style="font-size: 10pt;">NA'</SPAN></SPAN>),rgb(45,150,255),rgb(135,137,139)) <BR /></SPAN></P></BODY></HTML> Thu, 27 Feb 2014 16:24:14 GMT https://community.qlik.com/t5/QlikView/Help-on-formula/m-p/580297#M1116185 aveeeeeee7en 2014-02-27T16:24:14Z Re: Help on formula https://community.qlik.com/t5/QlikView/Help-on-formula/m-p/580298#M1116186 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>check reply given by</P><P><SPAN class="j-post-author"><STRONG><A _jive_internal="true" class="jiveTT-hover-user jive-username-link" data-avatarid="5689" data-externalid="" data-presence="null" data-userid="82367" data-username="Alexandros17" href="https://community.qlik.com/people/Alexandros17">Alessandro Saccone <BR /></A></STRONG></SPAN></P><P><SPAN class="j-post-author"><STRONG><BR /></STRONG></SPAN></P><P><SPAN class="j-post-author"><STRONG>It should work fine.<BR /></STRONG></SPAN></P></BODY></HTML> Thu, 27 Feb 2014 16:30:46 GMT https://community.qlik.com/t5/QlikView/Help-on-formula/m-p/580298#M1116186 PrashantSangle 2014-02-27T16:30:46Z