Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Help needed for chart Expression

Hi Everyone

I am Deepak, I am new to qlikview

I have a question

In one bar chart i have expression

Sum( {$<[Country]={'India'}>} [Quantity] )

which means to include only Country India for Quantity as Expression in chart

But i have to do opposite of this Expression

I want to Know how to Exclude Country India only, from Quantity Expression

For this how to write Expression

Any Answer would be helpful for me

Thanking you all

1 Solution

Accepted Solutions
Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

2 Replies
Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

Use operator "-=" ("minus equal") instead of "=", like this:

Sum( {$<[Country] -= {'India'}>} [Quantity] )

Not applicable
Author

Ok Thanks Oleg for your help