Skip to main content
Announcements
Qlik Connect 2025! Join us in Orlando join us for 3 days of immersive learning: REGISTER TODAY

Creating Harvey Balls Chart using SVG graphics

cancel
Showing results for 
Search instead for 
Did you mean: 
Kushal_Chawda

Creating Harvey Balls Chart using SVG graphics

Last Update:

Sep 27, 2024 7:56:02 AM

Updated By:

Kushal_Chawda

Created date:

Aug 28, 2024 11:29:22 AM

Attachments

The 'Measure Representation as Image' option is available in some Qlik Sense charts, enabling new possibilities for creating measures that return a simple text string where the text represents an SVG image. Note: This feature is supported in Qlik Sense versions from February 2024 onwards, as it utilizes the Visualization Bundle pivot table.

One of the visuals that can be produced using SVG images is the Harvey chart. To learn more about Harvey charts, refer to the link

To get started with SVG images, please refer to to the link

Here, you will find extensive tutorials:

 

SVG images can be utilised in native Qlik Sense charts such as the Table and Pivot Table visuals from the Visualisation Bundle. For this demonstration, I've used the Pivot Table from the Visualisation Bundle.

In this example, I used pie and donut charts to display percentages. These percentages represent product features and performance based on user votes. I've attached sample data and a QVF file for reference.

This method works best for positive percentages between 0 and 100. However, in cases where negative percentages are relevant, you can use the absolute value of the percentages to generate the SVG image, representing the negative percentage as text.

I've employed the fabs() function to handle negative percentage values. If negative percentages aren't relevant to your case, you can omit the use of fabs().

To ensure the SVG image fits properly, you’ll need to increase the font size of the pivot table cells. Additionally, you can adjust conditions to represent different colors as needed.

Here are some screenshots:

 

Screenshot 2024-08-28 at 16.18.33.pngScreenshot 2024-08-28 at 16.18.43.pngScreenshot 2024-08-28 at 16.18.53.pngScreenshot 2024-08-28 at 16.19.01.png

Labels (1)
Comments
rob_vander
Creator

Excellent Article

did
Employee

Really very interesting. Thank you!

culexronal
Contributor

Cool feature!

Unfortunately, after the installation I only see the formula “data:image/svg.... “ in the cells of the pivot table. Do I still have to set something so that the display switches to graphic display? When I switch the diagram to table, I see the pictures (displayed very small, of course).

I'm on Version May 2024. Bundle Version 14.187.4.

Contributors
Version history
Last update:
‎2024-09-27 07:56 AM
Updated by: