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: 
joeybird
Creator III
Creator 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
marcohadiyanto
Partner - Specialist
Partner - Specialist

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

View solution in original post

3 Replies
sunny_talwar

How about this:

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

joeybird
Creator III
Creator III
Author

Hi

no sorry, still happens,

its like if its rounding the 99.32

please help

marcohadiyanto
Partner - Specialist
Partner - Specialist

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