Solved: Row colour based on condition - Qlik Community

Anonymous · ‎2015-10-11

Need your help-

In the attached file i have created details tabluar chart-

I want to mark colour based on some condition-

1. If the Resolution time is greater than KPI time then mark it RED

2. if the resolution time less than KPI time then mark it green

3. NO -SLA- keept it Green

petter · ‎2015-10-11

Recreate your TableBox and make a StraightTable instead: letting every field including DT2 become Dimensions and make the rest into Expressions. Then you can use the "Background Color" property of the Expression for the "Resolution Time" have an If() as expression to give the right background color:

View solution in original post

MK_QSL · ‎2015-10-11

Resolution Time is in Time Format and KPI is in which format?

How you want to compare them?

Anonymous · ‎2015-10-11

Hi Suman,

There at the Resolution expression ,Right Click on it ,

you will find text color and Back ground Color ,

Then should right the expression like this,

=if([Resolution Time]<[Network Day Solved],green(),

if([Resolution Time]>[Network Day Solved],Red(),White()))

Thanks,

Bunny

Anonymous · ‎2015-10-11

Here i have query that what should we compare 'KPI time' Means??

Anonymous · ‎2015-10-11

resolution time hh:mi:ss

kpi time-hh

Anonymous · ‎2015-10-11

Time provided to resolve the ticket

MK_QSL · ‎2015-10-11

You can use below expression in BackGround color..

IF(DurationStefan > Time#(KPI_TIME,'h'), Red(), Green())

Anonymous · ‎2015-10-11

I am not able to find -Resolution expression..Please help

Anonymous · ‎2015-10-11

i .e Network Day solved right ?? !

Anonymous · ‎2015-10-11

Here you can see in the attached app of yours.

Thanks,

Bunny