Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
rafael5958
Creator
Creator

change values on listbox

Hi, what do I have is:

COL1COL2
AAAAAA
BBBBBB
CCCCCC
DDDMMM
EEEZZZ
FFFSSS
GGG 
HHH 

 

My listbox has the expression

 

COL1=COL2

 

 

It returns the values 0 and -1.

I want to show only the value -1 ( when the values are equal), and change the value -1 for the text "Equal Values".

Is it possible??

1 Solution

Accepted Solutions
shiveshsingh
Master
Master

Hi

Please use this expression in listbox.

 

=if(COL1=COL2,'Equal Values')

View solution in original post

1 Reply
shiveshsingh
Master
Master

Hi

Please use this expression in listbox.

 

=if(COL1=COL2,'Equal Values')