topic How to flag when expression outputs do not match in QlikView

How to flag when expression outputs do not match

Anonymous — Sat, 07 Jan 2012 03:13:59 GMT

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' ?

How to flag when expression outputs do not match

Sat, 07 Jan 2012 08:01:49 GMT

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

How to flag when expression outputs do not match

Anonymous — Sat, 07 Jan 2012 14:04:03 GMT

Yes, and thank you.