Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
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?

Thanks in advance for your help

Best regards

Nicolò Cogno

Tags (1)
1 Solution

Accepted Solutions
Partner
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.

View solution in original post

8 Replies
Khan_Mohammed
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.

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
Khan_Mohammed
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?

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 &

Khan_Mohammed
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?

Khan_Mohammed
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.

Partner
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.

View solution in original post

Not applicable

Re: Show percentage in Tree Map

All right, thanks!