topic change values on listbox in QlikView https://community.qlik.com/t5/QlikView/change-values-on-listbox/m-p/1614894#M596498 <P>Hi, what do I have is:</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>COL1</TD><TD>COL2</TD></TR><TR><TD>AAA</TD><TD>AAA</TD></TR><TR><TD>BBB</TD><TD>BBB</TD></TR><TR><TD>CCC</TD><TD>CCC</TD></TR><TR><TD>DDD</TD><TD>MMM</TD></TR><TR><TD>EEE</TD><TD>ZZZ</TD></TR><TR><TD>FFF</TD><TD>SSS</TD></TR><TR><TD>GGG</TD><TD>&nbsp;</TD></TR><TR><TD>HHH</TD><TD>&nbsp;</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>My listbox has the expression</P><P>&nbsp;</P><LI-CODE lang="markup">COL1=COL2</LI-CODE><P>&nbsp;</P><P>&nbsp;</P><P>It returns the values 0 and -1.</P><P>I want to show only the value -1 ( when the values are equal), and change the value -1 for the text "Equal Values".</P><P>Is it possible??</P> Wed, 21 Aug 2019 14:16:58 GMT rafael5958 2019-08-21T14:16:58Z change values on listbox https://community.qlik.com/t5/QlikView/change-values-on-listbox/m-p/1614894#M596498 <P>Hi, what do I have is:</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>COL1</TD><TD>COL2</TD></TR><TR><TD>AAA</TD><TD>AAA</TD></TR><TR><TD>BBB</TD><TD>BBB</TD></TR><TR><TD>CCC</TD><TD>CCC</TD></TR><TR><TD>DDD</TD><TD>MMM</TD></TR><TR><TD>EEE</TD><TD>ZZZ</TD></TR><TR><TD>FFF</TD><TD>SSS</TD></TR><TR><TD>GGG</TD><TD>&nbsp;</TD></TR><TR><TD>HHH</TD><TD>&nbsp;</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>My listbox has the expression</P><P>&nbsp;</P><LI-CODE lang="markup">COL1=COL2</LI-CODE><P>&nbsp;</P><P>&nbsp;</P><P>It returns the values 0 and -1.</P><P>I want to show only the value -1 ( when the values are equal), and change the value -1 for the text "Equal Values".</P><P>Is it possible??</P> Wed, 21 Aug 2019 14:16:58 GMT https://community.qlik.com/t5/QlikView/change-values-on-listbox/m-p/1614894#M596498 rafael5958 2019-08-21T14:16:58Z Re: change values on listbox https://community.qlik.com/t5/QlikView/change-values-on-listbox/m-p/1614904#M596499 <P>Hi</P><P>Please use this expression in listbox.</P><P>&nbsp;</P><P>=if(COL1=COL2,'Equal Values')</P> Wed, 21 Aug 2019 14:29:03 GMT https://community.qlik.com/t5/QlikView/change-values-on-listbox/m-p/1614904#M596499 shiveshsingh 2019-08-21T14:29:03Z