topic Show % in Treemap in Data Movement & Streaming

Show % in Treemap

Nemo1 — Wed, 19 Mar 2025 22:11:20 GMT

Hello everyone,

I would like to show the % in my treemap. how can i do that?

the current treenmap i have shows the dimension that i chose and it is divided by the measure, but i would also like to have written in it which % the dimension represents.

thanks

Re: Show % in Treemap

theoat — Tue, 02 Apr 2024 10:02:05 GMT

Hello Nemo,

You can use the function Dual().

For exemple :

dual(num(sum(Amount)/sum(Total Amount)*100,'#,##0.00') & '%',sum(Amount))

You have to set the format of the expression on "Measure expression".

Enjoy your Qlik.

Kind regards,
Théo ATRAGIE.

Re: Show % in Treemap

Nemo1 — Tue, 02 Apr 2024 10:53:03 GMT

hey, it did work, thanks.

The only thing tho, is that I get the % only when I hover over the dimension, I would like to see the % always written on the treemap, is that possible?

Re: Show % in Treemap

theoat — Tue, 02 Apr 2024 12:12:13 GMT

Presentation --> Value label

Enjoy your Qlik.

Kind regards,
Théo ATRAGIE.

Re: Show % in Treemap

Nemo1 — Tue, 02 Apr 2024 12:14:35 GMT

merci!