Sankey diagram, data represented in %

[Maria_S]

Hello Qlik Community,

Could you please help me to find a solution whether is it possible to display a Sankey diagram with data represented as percentages in QlikSaaS?

Thank you very much for your help!

[Frank_S]

You should be able to achieve your objective for the measure field of the sankey chart as seen in the following image.

• Go to the data options in your sankey chart object
• choose 'measure' and use the average function or as needed
• switch to 'number' format
• enable the percentage format that you prefer

[Maria_S]

Hello Frank_S,

thank you for the reply!

If I follow your advice, I get values multiplied by 100%, but not the A/B/C percentages from the total, similar to what is shown in your screenshot.

I also tried changing the measurement from Count(DISTINCT id) to Count(DISTINCT id) / Count(id), but that didn’t work either.

Maria

[Frank_S · Accepted solution]

@Maria_S 

Go ahead and report a defect by starting a Qlik Support Case.

Explain your

• expected results as you have done here along with
• detailed steps to reproduce the issue.
• Ensure to share a set of images or a video of the what you are experiencing

Kind regards...