Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
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
Partner

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

There is a difference between -=  and =-

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

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

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

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