topic Re: what does a -={} in set analysis exactly do ? in QlikView

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

walid_ballout — Wed, 25 Nov 2020 16:16:04 GMT

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.

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

markusjahr — Wed, 29 Mar 2017 08:02:42 GMT

It means "not equal to "

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

walid_ballout — Wed, 29 Mar 2017 08:05:23 GMT

Not equal to Null ? specifically right ?

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

markusjahr — Wed, 29 Mar 2017 08:12:37 GMT

not equal to the selected Subcategory

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

vinieme12 — Wed, 29 Mar 2017 08:13:00 GMT

There is a difference between -= and =-

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

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

walid_ballout — Wed, 29 Mar 2017 08:33:29 GMT

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

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

jonathandienst — Wed, 29 Mar 2017 08:40:31 GMT

-= means exclude.

{} means the empty set

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

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

jonathandienst — Wed, 29 Mar 2017 08:41:18 GMT

To exclude blank values use

a -= {''}

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

walid_ballout — Wed, 29 Mar 2017 08:46:17 GMT

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-={}

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

jonathandienst — Wed, 29 Mar 2017 09:00:24 GMT

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