topic Why does this simple minus equal "-=" set analysis not work? in QlikView

Why does this simple minus equal "-=" set analysis not work?

mazacini — Tue, 27 Sep 2011 16:08:46 GMT

I am getting the red error mark on the minus signon this expression:

=SUM({$<Target-={'y')>} TR.VAUE)

When I drop the minus sign, there is no error. Error also present if I replace minus with plus ie +=

Any ideas?

Why does this simple minus equal "-=" set analysis not work?

swuehl — Tue, 27 Sep 2011 16:21:55 GMT

Afaik that is a Bug in the expression dialog.

Does the expression evaluates?

Why does this simple minus equal "-=" set analysis not work?

jduenyas — Tue, 27 Sep 2011 16:59:09 GMT

I believe this is a bug in QlikView. You will also notice that after the '-=', '+=', '*=' the intellisense (the feature that completes the typed function name or field name) is not working. Since I like this feature I always set my set analysis to the '=' sign, complete the statement and then change to '-=' or any of the others.

Why does this simple minus equal "-=" set analysis not work?

jduenyas — Tue, 27 Sep 2011 17:05:54 GMT

By the way, the expression should evaluate correctly even the 'error' squigly line is showing. If it does not evaluate correctly for you make sure that you evaluate to the right value -- Target-={'y') is not the same as Target-={'Y') (Case sensitive)

Why does this simple minus equal "-=" set analysis not work?

jonathandienst — Tue, 27 Sep 2011 17:52:38 GMT

Agree that this is a bug in the expression dialog syntax check and can be igmored.

Regards

Jonathan