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: 
Anonymous
Not applicable

How to flag when expression outputs do not match

If expression output  (1) "ABC"  = "123"

and another expresion output (2)  "DEF" = "123"

How do I set another expression output  (3) where IF (1)=(2), 'OK', 'ERROR'  ?

1 Solution

Accepted Solutions
Not applicable
Author

Hi there,

Within a chart you can refer to previously set expressions in subsequen expressions by their name in square brackets. eg if expression 1 is called A and expression 2 is called B you can refer to them with and .

You have nearly answered your own question there.

Use an if statement to compare the two:

if([ABC] = [DEF],'OK','ERROR')

Is this what you are after?

Regards,

Erica

View solution in original post

2 Replies
Not applicable
Author

Hi there,

Within a chart you can refer to previously set expressions in subsequen expressions by their name in square brackets. eg if expression 1 is called A and expression 2 is called B you can refer to them with and .

You have nearly answered your own question there.

Use an if statement to compare the two:

if([ABC] = [DEF],'OK','ERROR')

Is this what you are after?

Regards,

Erica

Anonymous
Not applicable
Author

Yes, and thank you.