Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
gkcchowdary
Creator
Creator

Display the country wise chart excluding Indian and us?

Hi

I have country filed.i want display the country wise sales excluding Indian and us.how to write the expression.

Thanks

Chaitanya

4 Replies
rohitraut
Creator
Creator

Hello try this,

Sum({<Country -={'Indian','US'}>}Sales)

OR

If(Country <> 'Indian' or Country <> 'US' , sum(Sales))

Anil_Babu_Samineni

These are basic functionality in Set analysis if you read basic concepts in help from community / Help in qlik

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
vinieme12
Champion III
Champion III

Refer this thread for more on Set Analysis

Set Analysis: syntaxes, examples

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
jagan
Luminary Alumni
Luminary Alumni

Hi Chaitanya,

You can exclude certain values by using -= in set analysis like below

=Sum({<Country-={'India', 'US'}>} Sales)

You can learn more about qliksense in below links

Set analysis and set expressions ‒ Qlik Sense

Hope this helps you.

Regards,

Jagan.