topic Current selection includes specific string in QlikView https://community.qlik.com/t5/QlikView/Current-selection-includes-specific-string/m-p/638414#M678059 <HTML><HEAD></HEAD><BODY><P>I am trying to create a conditional expression for a button that changes its color based whether a certain entry in a field is selected. This is what it looks like:</P><P></P><P>if(loanType = 'Mortgage", rgb(32,200,53), rgb(196,0,0))</P><P></P><P>This only works if only that specific entry in the loanType field is selected. Once I select another loan type on top of Mortgage the loanType = 'Mortgage' expression is no longer true even though Mortgage is still selected. Is there an expression that I can use that remains true as long as Mortgage is selected, regardless of whether any other entries in that field are also selected?</P><P></P><P>Thanks for the help.</P></BODY></HTML> Mon, 19 May 2014 15:30:15 GMT 2014-05-19T15:30:15Z Current selection includes specific string https://community.qlik.com/t5/QlikView/Current-selection-includes-specific-string/m-p/638414#M678059 <HTML><HEAD></HEAD><BODY><P>I am trying to create a conditional expression for a button that changes its color based whether a certain entry in a field is selected. This is what it looks like:</P><P></P><P>if(loanType = 'Mortgage", rgb(32,200,53), rgb(196,0,0))</P><P></P><P>This only works if only that specific entry in the loanType field is selected. Once I select another loan type on top of Mortgage the loanType = 'Mortgage' expression is no longer true even though Mortgage is still selected. Is there an expression that I can use that remains true as long as Mortgage is selected, regardless of whether any other entries in that field are also selected?</P><P></P><P>Thanks for the help.</P></BODY></HTML> Mon, 19 May 2014 15:30:15 GMT https://community.qlik.com/t5/QlikView/Current-selection-includes-specific-string/m-p/638414#M678059 2014-05-19T15:30:15Z Re: Current selection includes specific string https://community.qlik.com/t5/QlikView/Current-selection-includes-specific-string/m-p/638415#M678060 <HTML><HEAD></HEAD><BODY><P>Try with this expression:</P><P></P><P>if(WildMatch(concat(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12.800000190734863px;">loanType </SPAN>),'*<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12.800000190734863px;">Mortgage</SPAN>*')<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12.800000190734863px;">, rgb(32,200,53), rgb(196,0,0))</SPAN></P></BODY></HTML> Mon, 19 May 2014 15:37:17 GMT https://community.qlik.com/t5/QlikView/Current-selection-includes-specific-string/m-p/638415#M678060 2014-05-19T15:37:17Z Re: Current selection includes specific string https://community.qlik.com/t5/QlikView/Current-selection-includes-specific-string/m-p/638416#M678061 <HTML><HEAD></HEAD><BODY><P>Works great, thank you.</P></BODY></HTML> Mon, 19 May 2014 15:43:37 GMT https://community.qlik.com/t5/QlikView/Current-selection-includes-specific-string/m-p/638416#M678061 2014-05-19T15:43:37Z