topic Translate expression to variable in QlikView

Translate expression to variable

Anonymous — Sun, 01 Jan 2012 22:10:53 GMT

How come

=IF(System_1 = System_2, '1', '0')

returns 1 when the fields are equal if I use it in an expression, but returns 0 if I create a variable out of it vSystem_Match and put that in my chart as either a dimension or an expression? (With $ expansion)

Translate expression to variable

swuehl — Sun, 01 Jan 2012 23:51:36 GMT

Try defining your variable like

if(System_1 = System_2,'1','0')

i.e. without the equal sign. There is a more than subtle difference in using the equal sign and not using it

Then reference the variable in your expression like:

=$(vSystem_Match)

Hope this helps,

Stefan

Translate expression to variable

Anonymous — Mon, 02 Jan 2012 00:03:06 GMT

Thank you Stefan!

Jonathan