topic Re: Bubble layer association in GeoAnalytics

Bubble layer association

fabdulazeez — Sun, 09 Jul 2017 11:13:52 GMT

I would like to display same bubble layer twice and make them independent as we do in set analysis. The use case is to display all the customers irrespective of selection on map

Re: Bubble layer association

Patric_Nordstrom — Tue, 11 Jul 2017 11:42:28 GMT

Hi Fawaz,

That is possible in Qlik GeoAnalytics, add a measure like this Sum({1}1) to modify the dimension so that all values are visible.

Thanks,

Patric

Re: Bubble layer association

Ana_Yakushi — Tue, 11 Jul 2017 11:45:04 GMT

Hello Fawaz,

I think you can use one of these:

You need to use a set analysis to make the measure(s) ignore the points filtering.

For example, I had an ID, latitude and longitude for each datapoint. Then in the "Location, Size" section:

Avg({<ID=>} latitude)

Avg({<ID=>} longitude)

The same if you have other measures for size and color:

Sum({<ID=>} sales)

Remember to add all other dimensions to be ignored, like: Sum({<ID=,category=>} sales)

You can create a copy of the customer table renaming the fields so it will be completely independent of other tables in your data model.

Then use these fields in your Bubble Layer. Since it doesn't have any common field with other tables, the filters won't affect the bubbles.

Best Regards,

Ana Yakushi

Qlik GeoAnalytics

Re: Bubble layer association

fabdulazeez — Tue, 11 Jul 2017 11:54:42 GMT

Yeah i already tried the second option. Thanks for the support. May be i'll try first option and get back on that.

Re: Bubble layer association

Ana_Yakushi — Tue, 11 Jul 2017 12:33:48 GMT

Hello Faraz,

Looking at Patric's answer, I think his expression is simpler because you don't need to specify the dimensions to be ignored by the filter. Just remember to apply the same to all of the measures (including latitude and longitude calculations) in the bubble layer.

Best Regards,

Ana Yakushi

Qlik GeoAnalytics

Re: Bubble layer association

fabdulazeez — Wed, 12 Jul 2017 06:48:50 GMT

Can you please explain reccomendation. Should i be adding an additional measure like sum({1}1) or should i be modifying latitude an longitude

Re: Bubble layer association

fabdulazeez — Thu, 10 Aug 2017 08:24:58 GMT

I don't understand how to apply sum({1}1) to latitude and longitude or dimension. Can you explain a little more. Sorry for the late response.i was to able get result on qlik normal map but not on geoanalytics

Re: Bubble layer association

Patric_Nordstrom — Fri, 15 Sep 2017 10:39:51 GMT

Hi Fawaz,

The key is the set analysis expression, '{1}', to make the layer to ignore any selections that have been done.

So for a numeric lat or long I would use avg({1} lat) to get the desired result.

For string value something like maxstring({1} state_name) would work fine.

Thanks,

Patric

Re: Bubble layer association

tman — Fri, 10 Mar 2023 14:46:42 GMT

@Patric_Nordstrom newbe to sense.

I have an inscript makegeopoint(lat,long) as LOCATION

when i add {1}LOCATION to my point layer location dimension LOTNAME i get the desired affect of not filtering my points on map. however I lost the automatic Zoom on the map? And every time i go to a different sheet and back to the MAP sheet it zooms back out to the entire points layer.

Is there a work around??

thanks

TMAN