Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi, you can use set analysis in your expressions, e.g.
Sum({<Tipo={'Infrastrutturale'}>}Costs
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
Create your calculated dimension like this:
Aggr(Only({<Tipo={'Infrastrutturale'}>}Country), Country)
-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com
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 😞
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