Expression works in table object but does not work in Map object

[Gau1]

Hi All,

I have below expression which works in table object but does not work in Map object

Sum( {<region_exco={$(=concat( distinct chr(39) & region_exco & chr(39),',') )},reporting_unit=>} 1)

The business requirement is when "reporting unit" is selected it should show  all the "reporting unit" from that "region_exco".

Can anyone help me in this please.

Thanks in advance.

Regards,

GG

[anat]

can you try with P function

https://help.qlik.com/en-US/sense/November2023/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/SetAn...

Sum( {<region_exco=p(region_exco),reporting_unit=>} 1)

[Gau1]

Hi Anat,

Thanks for your reply.

But this is also not working.

[anat]

if possible can you share sample data and expected output...

[vinieme12]

The business requirement is when "reporting unit" is selected it should show  all the "reporting unit" from that "region_exco".

why would you need to use set analysis for filtering associated values when Qlik does that by default??

=Sum( 1)

[Gau1]

Hi, 

"reporting unit" are cities and "region_exco" are respective countries. When the user selects one city the all the cities from that country should be visible in the Map chart. This is the requirement.

Can you please help me in this.

Regaards,

Gaurav 

[vinieme12]

Then you need to associate those fields in the data model