Qlik Community

Ask a Question

GeoAnalytics

Discussion Board for collaboration regarding Qlik GeoAnalytics.

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
samuelll
Contributor
Contributor

geomap chart layer for pie charts per region not showing percentage

Hi Guys ... hope you can help ...

I'm building a geomap layer with QlikView (not QlikSense) in my model. I want to show pie-charts per region (province) for my country based on total sales per product.

The pie chart shows up fine, but the information bubble only has the actual values, not the percentage contribution per  product. I managed to find a formula that adds the percentage value to the dimension, but it only calculates over the entire dataset, not per province. As a result, the % values in the dimension is the same for all provinces.

I don't even care to show the value as in the image below if I can just have the % contribution instead... like FNB = 21% and Other = 79% .... 

 

 

.Capture.JPG

3 Replies
rushikale0106
Contributor III
Contributor III

Hi @samuelll ,

To find the data in percentage, convert the expression in relative form. In the Expression tab, you can find the Relative Checkbox.

It might solve your problem of values in percentage. Please check the attached image

If it does, mark the answer as a solution so that it will help others.

 

Regards,

Rushi

samuelll
Contributor
Contributor
Author

Hi @rushikale0106  ... unfortunately that tick option only works for a normal chart. My problem is specific to a chart layer on a geomap where those additional options don't reflect/exist.

Patric_Nordstrom
Employee
Employee

@samuelll 

Modify the expression in this way to get percentage. Replace Country with your province field and COS with your measure.

round(sum(COS)/sum(total <Country> COS)*100)