Color condition in qliksense table

Aspiring_Developer — Thu, 23 Sep 2021 09:18:14 GMT

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

Re: Color condition in qliksense table

stevejoyce — Thu, 23 Sep 2021 10:41:56 GMT

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

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

100 % -> 1 in the condition

Re: Color condition in qliksense table

Aspiring_Developer — Thu, 23 Sep 2021 13:15:51 GMT

Hello @stevejoyce

I tried , it says 'error is expression'

Thanks

topic Re: Color condition in qliksense table in App Development

Color condition in qliksense table

Re: Color condition in qliksense table

Re: Color condition in qliksense table