Show % in Treemap

[Nemo1]

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

[theoat]

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.

[Nemo1]

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? 

[theoat · Accepted solution]

Presentation --> Value label

Enjoy your Qlik.

Kind regards,
Théo ATRAGIE.

[Nemo1]

merci!