Qlik Community

Qlik Sense App Development

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

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
joeybird
Contributor III

issue

Hi

have issue with colour of background expression , with percentage calculation

  if(sum([Processed In 8 Hours])/SUM([Total Customers])>= 1, green(), yellow())

I am using this on a table chart.

issue I have that on a Date that the percentage is 99.32%...because of this it will colour the background yellow. I need to only if exact 100.00% it is yellow

I need the percentage to show in this format, so rounding is not an option

please help

1 Solution

Accepted Solutions
chooco_co
Valued Contributor

Re: issue

Hi Joanna,

try this for your background color and just use your measurement for your value

if(ceil(sum([Processed In 8 Hours])/SUM([Total Customers]))>= 1, green(), yellow())


Regards,

Marco

3 Replies

Re: issue

How about this:

If(Sum([Processed In 8 Hours])/Sum([Total Customers]) = 1, Yellow(), Green())

joeybird
Contributor III

Re: issue

Hi

no sorry, still happens,

its like if its rounding the 99.32

please help

chooco_co
Valued Contributor

Re: issue

Hi Joanna,

try this for your background color and just use your measurement for your value

if(ceil(sum([Processed In 8 Hours])/SUM([Total Customers]))>= 1, green(), yellow())


Regards,

Marco