Percentage of Total Count on Treemap

[ltc]

Hi,

I need help changing the way my treemap is displayed.  On the attached screenshot, the count of inquiries is displayed for each different application.  How can I change the count number to the percentage of the total count?  Instead of having the number 105 displaying under CCaR, I need it to show 41.1%  (105/255). 

I didn't see it as an option under appearance.  If I have to do an expression, please let me know what the expression would be.  For the purpose of creating an expression, my current measure expression is Count(Application).

Thank you!

[sudhirpkuwar]

Are you doing it in QlikView or Qlik Sense....?

[vishalarote]

Go to expression tab and make it Relative Checkbox on

hope so it will works.

[bhaskar_sm · Accepted solution]

Hi,

you can use below expression to show the values in % irrespective of total value

=num(Count(Application)/ Count(total Application ),'#,##0.00%')

and you need to Select number formatting as Measure Expression.

in my case i have used this expression =num(sum([BILLED QUANTITY])/sum(total [BILLED QUANTITY]),'#,##0.00%')

if you found this helpful, please mark as helpful or correct 

Regards.

Bhasker Kumar

[ltc]

Thank you so much!  The expression worked.  I didn't have "measure expression" on the drop down.  See screenshot.  Any idea why?

[ltc]

I've never seen a screen like this in Qlik Sense before.  Is your screenshot from Qlik Sense or somehwere else?

[ltc]

Qlik Sense

[bhaskar_sm]

i am using latest vesion - qlik sense feb 2018, which has this option

[ltc]

‌cool, thanks.  how can I find out which version I’m using?

[bhaskar_sm]

PFB - Goto->top  -> right hand corner-Click on that-->then About-> then Version will shown