Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ilanbaruch
Specialist
Specialist

color expression value as percentage

hi all ,

added to color by expression the below

num((count(users)/sum(accounts))*100,'#,##0%')

unchecked the expression is a color code , when standing with cursor it shows the correct number without the percentage (%) sign

any ideas?

Labels (1)
10 Replies
sunny_talwar

So what exactly is your issue? You want to see the percentage sign?

ilanbaruch
Specialist
Specialist
Author

yes

migueldelval
Specialist
Specialist

Hi ilan,


Try With this expression


=num((count(users)/sum(accounts))*100,'#,##0')&' %'


Regards


Miguel del Valle

lakshmikandh
Specialist II
Specialist II

Number formatting will not apply in color expression.

shraddha_g
Partner - Master III
Partner - Master III

in color by expression you don't need to have number formatting with % sign. You just have to decide a proper range and assign colors accordingly.

imrencimen
Contributor III
Contributor III

Expression:


=num((count(users)/sum(accounts)),'#,##0%')


Text Color Expression:


if((count(users)/sum(accounts))<0,RED(),GREEN())

ilanbaruch
Specialist
Specialist
Author

Thank you Miguel , but it didn't work

sunny_talwar

Can you share some screenshots of what you are seeing?

ilanbaruch
Specialist
Specialist
Author

no but its straight foreword - when standing with cursor on the bubble, in the tooltip  i'm seeing the correct number format i.e(2.7) - only the percentage sign (%)  is missing

thank you