topic Filter on Chart in QlikView

Filter on Chart

qlikviewaf — Thu, 15 Jun 2017 12:58:38 GMT

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 — Thu, 15 Jun 2017 13:08:37 GMT

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 — Thu, 15 Jun 2017 13:41:41 GMT

In your Dimension for Area write like?

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

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

Then Check Supress Null Values for that dim.

avinashelite — Thu, 15 Jun 2017 13:43:40 GMT

try like this

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

Anil_Babu_Samineni — Thu, 15 Jun 2017 13:47:43 GMT

Or this? If you have more than limit for Area

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