Set selection in a map

[mariovella]

Hi

I have  data on several  public projects, I want to analyse them in term of type of project (Tipo).

I want to show a map for each type (var: [Tipo]) of project (in the example: Infrastrutturale, SCC, Velocizzazione) .

How can I insert this instruction in  the map?

Thanks in advance for any help

Mario

[Ivan_Bozov]

Hi, you can use set analysis in your expressions, e.g.

Sum({<Tipo={'Infrastrutturale'}>}Costs

[mariovella]

Thank you Ivan for your feeeback

Your solution works perfectly if I want to work with a measure linked to a dimension

I need a solution for a case where I just want to filter a dimension in a map (no direct link with a measure)

How can I achieve that? Can you help me?

Thanks again

Maio

[rwunderlich]

Create your calculated dimension like this:

Aggr(Only({<Tipo={'Infrastrutturale'}>}Country), Country)

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

[mariovella]

Rob

thanks for your contribution, but it does not seem to work properly (see attach)

Tha map onn the right has a conditional calculation..... but with no success 😞

[rwunderlich · Accepted solution]

I think you misunderstood my suggestion.  Calculation Condition controls if the map is shown. It does not filter the data. 

To filter the data, you should use the suggested aggr() expression in your Dati section as the Dimensione.   Example attached. 

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com