Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
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
(see also http://www.qlikfix.com/2011/06/08/not-all-variables-are-created-equal/ )
Then reference the variable in your expression like:
=$(vSystem_Match)
Hope this helps,
Stefan
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
(see also http://www.qlikfix.com/2011/06/08/not-all-variables-are-created-equal/ )
Then reference the variable in your expression like:
=$(vSystem_Match)
Hope this helps,
Stefan
Thank you Stefan!
Jonathan