Discussion board where members can learn more about Qlik Sense App Development and Usage.
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
Go to Solution.
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())
How about this:
If(Sum([Processed In 8 Hours])/Sum([Total Customers]) = 1, Yellow(), Green())
no sorry, still happens,
its like if its rounding the 99.32