How to report specific country's value

[Anonymous]

Hi there,

I have a data set of sales for different country and different product. I am trying to generate a chart that only report the value in US market. How should I define the measure in my chart without adding a filter pane next to it?

Thanks ahead.

[pradosh_thakur]

something similar to this ?

you may need to provide some sample data

sum({<country={'US'}>}sales)

[OmarBenSalem · Accepted solution]

u might want to ake a look at set analysis:

please refer to:

Set analysis and set expressions ‒ QlikView

https://community.qlik.com/docs/‌DOC-4951

Learning Set Analysis from Scratch