Bubble layer association

[fabdulazeez]

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

[Patric_Nordstrom]

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

[Ana_Yakushi · Accepted solution]

Hello Fawaz,

I think you can use one of these:

1)

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)

2)

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

[fabdulazeez]

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

[Ana_Yakushi]

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

[fabdulazeez]

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

[fabdulazeez]

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

[Patric_Nordstrom]

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

[tman]

@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