Creating Harvey Balls Chart using SVG graphics

Kushal_Chawda — Fri, 27 Sep 2024 11:56:02 GMT

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:

Re: Creating Harvey Balls Chart using SVG graphics

rob_vander — Wed, 28 Aug 2024 19:51:14 GMT

Excellent Article

Re: Creating Harvey Balls Chart using SVG graphics

did — Fri, 11 Oct 2024 16:59:04 GMT

Really very interesting. Thank you!

Re: Creating Harvey Balls Chart using SVG graphics

culexronal — Wed, 11 Dec 2024 12:19:06 GMT

Cool feature!

Unfortunately, after the installation I only see the formula “data&colon;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.

article Creating Harvey Balls Chart using SVG graphics in Member Articles

Creating Harvey Balls Chart using SVG graphics

Re: Creating Harvey Balls Chart using SVG graphics

Re: Creating Harvey Balls Chart using SVG graphics

Re: Creating Harvey Balls Chart using SVG graphics