topic Re: Row colour based on condition in QlikView

Row colour based on condition

Anonymous — Sun, 11 Oct 2015 07:46:26 GMT

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

Re: Row colour based on condition

MK_QSL — Sun, 11 Oct 2015 07:57:04 GMT

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

How you want to compare them?

Re: Row colour based on condition

Anonymous — Sun, 11 Oct 2015 08:04:07 GMT

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

Re: Row colour based on condition

Anonymous — Sun, 11 Oct 2015 08:05:57 GMT

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

Re: Row colour based on condition

Anonymous — Sun, 11 Oct 2015 08:14:21 GMT

resolution time hh:mi:ss

kpi time-hh

Re: Row colour based on condition

Anonymous — Sun, 11 Oct 2015 08:16:48 GMT

Time provided to resolve the ticket

Re: Row colour based on condition

MK_QSL — Sun, 11 Oct 2015 08:19:41 GMT

You can use below expression in BackGround color..

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

Re: Row colour based on condition

Anonymous — Sun, 11 Oct 2015 08:26:24 GMT

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

Re: Row colour based on condition

Anonymous — Sun, 11 Oct 2015 08:34:39 GMT

i .e Network Day solved right ?? !

Re: Row colour based on condition

Anonymous — Sun, 11 Oct 2015 08:37:07 GMT

Here you can see in the attached app of yours.

Thanks,

Bunny

Re: Row colour based on condition

Anonymous — Sun, 11 Oct 2015 09:28:06 GMT

I have noticed the change but where have you done it.

I have requested to change on DSLA sheet.Please help

Re: Row colour based on condition

Anonymous — Sun, 11 Oct 2015 09:34:52 GMT

In DSLA Sheet there is a table Box ,

and one more thing the field you are showing as KPI Time Should be of same format as Resolution time or else we should convert in this form 'HH:MM:SS' and we can apply it.

Can u please give me correct info , i can try and help.

Thanks ,

Bunny

Re: Row colour based on condition

petter — Sun, 11 Oct 2015 09:57:32 GMT

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: