Qlik Community

Qlik GeoAnalytics Discussions

Discussion Board for collaboration regarding Qlik GeoAnalytics.

fawazeez
Contributor

Bubble layer association

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

1 Solution

Accepted Solutions
Employee
Employee

Re: Bubble layer association

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

7 Replies
Employee
Employee

Re: Bubble layer association

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

Employee
Employee

Re: Bubble layer association

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

fawazeez
Contributor

Re: Bubble layer association

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

Employee
Employee

Re: Bubble layer association

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

fawazeez
Contributor

Re: Bubble layer association

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

fawazeez
Contributor

Re: Bubble layer association

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

Employee
Employee

Re: Bubble layer association

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

Community Browser