# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for
Did you mean:
Contributor III

## what does a -={} in set analysis exactly do ?

I saw in a set analysis expression something like Sum({< Category={'ABC'}, Subcategory-={} >} Amount).

Is this a legal expression in QlikView ?@@, and what does it exactly do because handling of Nulls is done in some other way as I read on different discussions.

1 Solution

Accepted Solutions
Partner

To exclude blank values use

a -= {''}

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
9 Replies
Contributor III

It means  "not equal to "

Contributor III
Author

Not equal to Null ? specifically right ?

Contributor III

not equal to the selected Subcategory

Champion II

There is a difference between -=  and =-

See attached app, make selections in the listbox to see what happens

Contributor III
Author

sure. there is difference between -= and =-.

i tried what you suggested and apparently they are trying to overcome that there are blank cells in the excel sheet that is loaded for that field (subcategory).

Partner

-= means exclude.

{} means the empty set

a -= {} means exclude the empty set. In other words, do nothing.

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

To exclude blank values use

a -= {''}

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

Thanks Jonathan. What you are saying is true. a-={''} excludes blanks in all environments.

However and strangely, if the data source is excel, blank values can also be excluded using a-={}

Partner

>>However and strangely, if the data source is excel, blank values can also be excluded using a-={}

I agree that is strange and possibly even a bug, so I would not rely on that.

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