Filter on Chart

[qlikviewaf]

Hi,

i have the followin table-chart. i would like only to have on the chart data for EMEA and APAC/LATM, excluding then the "Area-not-available".

How i can achieve this?

Thank you!

[thomaslg_wq]

Hi Antonio,

You have to declare it in your expression-measure using "set analsysis" - Set analysis and set expressions ‒ Qlik Sense

Assuming your measure is

sum(Sales)

Then it should be

sum({<Area-={'Area-not-available'}>}Sales)

[vishsaggi]

In your Dimension for Area write like?

= Aggr(If(Not Match(Area, 'Area-Not-Available'), Area), Area)

OR

= Aggr(Only({< Country -= {'EMEA'} >} Country), Country)

Then Check Supress Null Values for that dim.

[avinashelite]

try like this

sum({<Area={"*"}-{'Area-not-available'}>}Sales)

[Anil_Babu_Samineni]

Or this? If you have more than limit for Area

Sum({<Area ={'EMEA', 'APAC/LATM'} >} Sales)