topic Re: Set analysis: syntax error while excluding in QlikView

Set analysis: syntax error while excluding

Mon, 14 Dec 2015 19:12:54 GMT

Hello,

I've got the following issue with the set analysis sintax:

In the first expression I am successfully excluding values but I am hardcoding the expression making it unresponsive to user selections.

In the second expression I am also excluding values but the QV syntax check is pointing out a mistake. Although it works OK, when complemented with other expressions its behaviour turns inaccurate.

Does anybody got a clue of what I am not doing correctly here?

Thanks in advance.

Re: Set analysis: syntax error while excluding

Clever_Anjos — Mon, 14 Dec 2015 19:26:38 GMT

Relax, sometimes "-=" brings this type of message

Re: Set analysis: syntax error while excluding

sunny_talwar — Mon, 14 Dec 2015 19:27:22 GMT

You must be using a older version of QV where it used to show those red lines when you use -=. This was fixed sometime in SR8-10 I think.

Re: Set analysis: syntax error while excluding

eduardo_sommer — Mon, 14 Dec 2015 19:27:37 GMT

Hi,

This is a bug from the syntax checker of qlikview. It works Ok.

Eduardo

Re: Set analysis: syntax error while excluding

Mon, 14 Dec 2015 19:30:04 GMT

Hi Hernan. Yes, this bug happens but you must see up where say "Expression OK". If say it, your expression it's okey!

Regards

Re: Set analysis: syntax error while excluding

Mon, 14 Dec 2015 19:36:03 GMT

There is a bug in the syntax check -=.

Set Analysis - "Does not equal"

Re: Set analysis: syntax error while excluding

Gabriel — Mon, 14 Dec 2015 22:11:49 GMT

Hi,

I think you have to move the curly bracket close to the equal sign (-={}) there shouldn't be gap.

Also consider upgrading to latest version of QlikView if you haven't done that

Re: Set analysis: syntax error while excluding

HirisH_V7 — Tue, 15 Dec 2015 04:48:48 GMT

Hi,

Exclude and Include ,

-={}

+={}

This marks in red color by the editor . But desired output will be acquired.

Check out.

-HirisH