topic Re: What does -(Field='Y') means? in QlikView

What does -(Field='Y') means?

microwin88x — Thu, 13 Mar 2014 17:51:39 GMT

I have a field with 2 possible values: Y / N

What does it mean to type -(Field = 'Y') ?

Thanks!

Re: What does -(Field='Y') means?

Anonymous — Thu, 13 Mar 2014 17:53:14 GMT

if that is within an if statement, then it means you are checking if Field equals Y.

so the following statement in a text box will return "Field is Y" or "Field is N" depending on the selection.

=if(Field = 'Y', 'Field is Y', 'Field is N')

Re: What does -(Field='Y') means?

Gysbert_Wassenaar — Thu, 13 Mar 2014 17:53:28 GMT

It will return 1 if the value is Y. (Field = 'Y') will return true if the value of Field is Y and the value of true is -1. By multiplying it with -1, e.g. the minus sign in before the parentheses you get 1.