topic Re: Expression works in table object but does not work in Map object in App Development

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

Gau1 — Sat, 13 Jan 2024 05:20:48 GMT

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,

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

anat — Sat, 13 Jan 2024 08:06:32 GMT

can you try with P function

https://help.qlik.com/en-US/sense/November2023/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/SetAnalysis/set-modifiers-implicit-field-value-definitions.htm

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

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

Gau1 — Sat, 13 Jan 2024 08:08:07 GMT

Hi Anat,

Thanks for your reply.

But this is also not working.

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

anat — Sat, 13 Jan 2024 08:16:31 GMT

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

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

vinieme12 — Mon, 15 Jan 2024 02:49:46 GMT

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)

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

Gau1 — Mon, 15 Jan 2024 04:38:01 GMT

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

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

vinieme12 — Tue, 16 Jan 2024 02:19:29 GMT

Then you need to associate those fields in the data model