Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set analysis: syntax error while excluding

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.

Situación 1.png

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.

Situación 2.png

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

Thanks in advance.

1 Solution

Accepted Solutions
sunny_talwar

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.

View solution in original post

7 Replies
Clever_Anjos
Employee
Employee

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

sunny_talwar

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.

View solution in original post

eduardo_sommer
Partner
Partner

Hi,

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

Eduardo

Not applicable

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

Regards

Not applicable

There is a bug in the syntax check -=.

Set Analysis - "Does not equal"

Gabriel
Partner
Partner

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

HirisH_V7
Master
Master

Hi,

Exclude and Include ,

-={}

+={}

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

Check out.

-HirisH

HirisH
“Aspire to Inspire before we Expire!”