# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. Register by February 29th to save \$200. Learn More
Highlighted
Not applicable

## Show percentage in Tree Map

Hi everybody,

I'm using the Tree Map object to show the prices of the single components of a bigger object and I would like to add the percentage of those respect to the total price of the object. I tried with '/' and with div, but every time I get "Can't show the chart".

How can I solve this?

Best regards

Nicolò Cogno

Tags (1)
1 Solution

Accepted Solutions
Highlighted
Partner

## Re: Show percentage in Tree Map

You cannot do that in a Treemap. Use Pie chart instead, it shows both value and its corresponding share.

8 Replies
Highlighted
Honored Contributor II

## Re: Show percentage in Tree Map

Use the Number formatting to Number > 12% for the measure.

It depends on the measure you've given.

The output may vary from 12% to 123% or even 1234% but that's the default option already available.

If you expression is

Count(ABC) and the result is 2000, 4321,1234 etc..

then give

Count(ABC)/1000, which should give 20%,43% or 12%... and decimals can be added too in number formatting.

Highlighted
Not applicable

## Re: Show percentage in Tree Map

Thanks for your help. My problem is that I can see alteratively the numeric price and the percentage price while I'd like to see both as measures in the same place.

Do you know how could I do that?

Highlighted
Honored Contributor II

## Re: Show percentage in Tree Map

Can you share your app and expression you trying/want or perhaps an image of what you need?

Correct me if I'm wrong, you've 2 measures and you do not want to use one of the measure as 'Alternative Measure' but 2 measures as a single measure?

Highlighted
Not applicable

## Re: Show percentage in Tree Map

I'm sorry, but unfortunately I can't

It's a treemap where I have the name of the component as dimension and the price as measure and I'd like to see both the numeric price and the total price respect to the total price of the object, but I can only see one of them at a time, also when I try to show them with the &

Highlighted
Honored Contributor II

## Re: Show percentage in Tree Map

What are the expressions you using?

Can you please break it down for us?

Numeric Price: ?

Total Price: ?

And what you expect?

Highlighted
Honored Contributor II

## Re: Show percentage in Tree Map

If you've an expression (what you have now Vs what you expecting)  maybe someone else can help you?

I'm not an expert in expressions....

Thanks.

Highlighted
Partner

## Re: Show percentage in Tree Map

You cannot do that in a Treemap. Use Pie chart instead, it shows both value and its corresponding share.

Not applicable

## Re: Show percentage in Tree Map

All right, thanks!