Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

ilanbaruch
Contributor II

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?

10 Replies

Re: color expression value as percentage

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

ilanbaruch
Contributor II

Re: color expression value as percentage

yes

migueldelval
Valued Contributor

Re: color expression value as percentage

Hi ilan,


Try With this expression


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


Regards


Miguel del Valle

lakshmikandh
Valued Contributor II

Re: color expression value as percentage

Number formatting will not apply in color expression.

shraddha_g
Honored Contributor III

Re: color expression value as percentage

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
New Contributor III

Re: color expression value as percentage

Expression:


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


Text Color Expression:


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

ilanbaruch
Contributor II

Re: color expression value as percentage

Thank you Miguel , but it didn't work

Re: color expression value as percentage

Can you share some screenshots of what you are seeing?

ilanbaruch
Contributor II

Re: color expression value as percentage

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

Community Browser