Display the country wise chart excluding Indian and us?

[gkcchowdary]

Hi

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

Thanks

Chaitanya

[rohitraut]

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

[vinieme12]

Refer this thread for more on Set Analysis

Set Analysis: syntaxes, examples

[jagan]

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.