Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
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