Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Presentation --> Value label
Enjoy your Qlik.
Kind regards,
Théo ATRAGIE.
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.
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?
Presentation --> Value label
Enjoy your Qlik.
Kind regards,
Théo ATRAGIE.
merci!