Qlik Community

Qlik Sense App Development

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

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
ilanbaruch
Contributor III

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 III

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.

Partner
Partner

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 III

Re: color expression value as percentage

Thank you Miguel , but it didn't work

Highlighted

Re: color expression value as percentage

Can you share some screenshots of what you are seeing?

ilanbaruch
Contributor III

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