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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register 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

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

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

Ask me about Qlik Sense Expert Class!

View solution in original post

2 Replies
Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

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

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

Ask me about Qlik Sense Expert Class!
Not applicable
Author

Ok Thanks Oleg for your help