Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Negative sign in front of equation

Hi Dear all,

Can you clarify to me what the Negative sign in front of equation means? - =

Many thanks

Cheers

Kezy

10 Replies
PrashantSangle

Hi,

It means not equals to

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
Not applicable
Author

Hi

That means excluding.

Thank you.

Regards

tresesco
MVP
MVP

Perhaps, you got this somewhere in set expression.

'-' operator denotes Exclusion.

Example:

sum( {$<Product -= {OurProduct1, OurProduct2} >} Sales )
returns the sales for the current selection, but using an implicit exclusion of “OurProduct1” and “OurProduct2” from the list of selected products.

PrashantSangle


Yes..

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
Not applicable
Author

@Tereseco

Thank you so much.

Regards

Not applicable
Author

Kezban also FYI, when used in set analysis like this, the syntax check will highlight this as an error but it is in fact correct and will calculate as expected

amit_saini
Master III
Master III

Hi,

Ex: All MANUFACTURERs except those whose name begins with ENT

{<MANUFACTURER_LDESC = {"*"} - {"ENT*"}>}

{<MANUFACTURER_LDESC = - {"ENT*"}>}

Ex: All MANUFACTURERs of the selection + those whose name begins with ENT

{<MANUFACTURER_LDESC += {"ENT*"}>}

Ex: All MANUFACTURERs of the selection except those whose name begins with ENT

{<MANUFACTURER_LDESC -= {"ENT*"}>}

Thanks,
AS

Not applicable
Author

Hi Amit,

That is so helpful answer from many perspectives. Thanks a lot.

Regards

Kezy

amit_saini
Master III
Master III

Pleasure

Thanks,

AS