Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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] )

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

Not applicable
Author

Ok Thanks Oleg for your help