topic Re: GeoAnalytics for Qlikview Chart Layer Size in QlikView

GeoAnalytics for Qlikview Chart Layer Size

Dolphin — Wed, 17 Feb 2021 09:33:30 GMT

Hi All,

I have a Chart Layer (Pie Chart) for every location showing some distribution (Flag Field -> is, is not).

Now I want to size the whole pie chart according to the locations sales, but in QlikView there is only one size parameter, that seems to size all pie chart the same size.

The Documentation says there is a min and max input, but there is none.

Using Aggr also doesn't work, the chart always picks the total expression, not by location.
The formula works fine in a straight table using the location as dimension:

RangeMax($(vKPI) / Max(Total Aggr( $(vKPI), $(vField_Location))) * 15, 5)

Is it possible in GeoAnalytics for Qlikview to size the pie chart differently for each location?

Thanks and regards,

Johannes

Re: GeoAnalytics for Qlikview Chart Layer Size

rubenmarin — Sat, 20 Feb 2021 10:03:00 GMT

Hi @Dolphin, if first dimension is a location, go to 'Location options' and select 'Dimension' as location source, this way when you add a second measure it will change the size of the chart.

https://help.qlik.com/en-US/geoanalytics/Subsystems/GeoPropertiesS/Content/qliksense/qliksense-imap_reference-Chart-Layer.htm

Re: GeoAnalytics for Qlikview Chart Layer Size

Dolphin — Mon, 22 Feb 2021 09:44:19 GMT

Hi @rubenmarin

Thanks for answering.

In Qlikview i don't seem to have these options. I use GeoAnalytics in Qlikview and the options look a bit different.

Location Options of the chart layer look like this:

I also had an issue with the info bubble, showing only the values of the first dimension value of the pie chart and not the total value of the location. As you can guess, the Total Qualifier solved this issue but i didn't solve the sizing problem with it yet.

The fourmula in the radius input keeps getting calculated over all dimension, resulting in the same value for each location. It makes sense.. the way it looks, there is only one value to be set for all charts.
Hence my question if it is even possible in Qlikview to size each chart differently.

Re: GeoAnalytics for Qlikview Chart Layer Size

rubenmarin — Tue, 23 Feb 2021 18:08:38 GMT

Hi @Dolphin, I tested this on Sense, I don't ahve it on QlikView to test.

By the help (this time for qlikview) looks like there are 2 options for radius: min and max

https://help.qlik.com/en-US/geoanalytics/Subsystems/GeoPropertiesQV/Content/qlikview/qlikview-imap_reference-Chart-Layer.htm#anchor-6

By this configuration it looks that there is a possibility to set different pie chart sizes as it can be done in Qlik Sense.

Maybe this is available since some version of QV geoanalitycs and you have an older one?

Re: GeoAnalytics for Qlikview Chart Layer Size

Dolphin — Thu, 25 Feb 2021 07:57:12 GMT

Hi @rubenmarin ,

Thanks again for your input.

Unfortunately it is not possible in QlikView. I tested it thoroughly and a Qlik employee confirmed that it is not possible in QlikView.
I guess the documentation is incorrect and just shows the QlikSense implementation of GeoAnalytics.

Thanks for your effort.
Best Regards