Color condition in qliksense table

[Aspiring_Developer]

Hello Everyone,

I am using below formulae in my calculation :-

if(GetSelectedCount([User.Divison Name])>0,((Sum({<INPUT_DATE = {">=$(=Date(MonthStart(Max([INPUT_DATE]))))<=$(=Date(Max([INPUT_DATE])))"}>} NB_HOURS)

/

(only({<INPUT_DATE = {">=$(=Date(MonthStart(Max([INPUT_DATE]))))<=$(=Date(Max([INPUT_DATE])))"}>}Real_ActualDays)*8)) /count([Person Name])),

if(
GetSelectedCount([User.Department Name])>0,(Sum({<INPUT_DATE = {">=$(=Date(MonthStart(Max([INPUT_DATE]))))<=$(=Date(Max([INPUT_DATE])))"}>} NB_HOURS)

/

(only({<INPUT_DATE = {">=$(=Date(MonthStart(Max([INPUT_DATE]))))<=$(=Date(Max([INPUT_DATE])))"}>}Real_ActualDays)*8)),

(Sum({<INPUT_DATE = {">=$(=Date(MonthStart(Max([INPUT_DATE]))))<=$(=Date(Max([INPUT_DATE])))"}>} NB_HOURS)

/

(only({<INPUT_DATE = {">=$(=Date(MonthStart(Max([INPUT_DATE]))))<=$(=Date(Max([INPUT_DATE])))"}>}Real_ActualDays)*8))/count(distinct [User.Department Name])

)) // & '%'

Now inside the selection, i want to add colors on the basis of condition in %input completion column.

If % input completion >=100, green(), red().

I am unable to implement this condition inside this expression. The way to do it is add the color expression in background color option , however, i am unable to do it.

Can anyone please help ?

Thanks in advance

[stevejoyce]

if( [%Input Completion] >=1, green(), red() )

where [%Input Completion] is the label of your measure.

100 % -> 1 in the condition

[Aspiring_Developer]

Hello @stevejoyce 

I tried , it says 'error is expression'

Thanks