Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

mazacini
Contributor III

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

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?

1 Solution

Accepted Solutions
MVP
MVP

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

Afaik that is a Bug in the expression dialog.

Does the expression evaluates?

4 Replies
MVP
MVP

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

Afaik that is a Bug in the expression dialog.

Does the expression evaluates?

jduenyas
Contributor III

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

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.

jduenyas
Contributor III

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

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)

MVP
MVP

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

Hi

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

Regards

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein