Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
walid_ballout
Contributor III
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
jonathandienst
Partner - Champion III
Partner - Champion III

To exclude blank values use

a -= {''}

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

View solution in original post

9 Replies
markusjahr
Contributor III
Contributor III

It means  "not equal to "

walid_ballout
Contributor III
Contributor III
Author

Not equal to Null ? specifically right ?

markusjahr
Contributor III
Contributor III

not equal to the selected Subcategory

vinieme12
Champion III
Champion III

There is a difference between -=  and =-

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

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
walid_ballout
Contributor III
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).

jonathandienst
Partner - Champion III
Partner - Champion III

-= 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
jonathandienst
Partner - Champion III
Partner - Champion III

To exclude blank values use

a -= {''}

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
walid_ballout
Contributor III
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-={}

jonathandienst
Partner - Champion III
Partner - Champion III

>>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