topic Re: How to mark equal values in rows in Green colour in QlikView

How to mark equal values in rows in Green colour

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

i want if in last two columns (according to my application ) any two values are equal then mark it as Green and if not then it should be marked in red color.

Re: How to mark equal values in rows in Green colour

Anil_Babu_Samineni — Mon, 04 Sep 2017 04:28:01 GMT

Normally we can do some thing like below unless provide more information

If(Expression1 = Expression2, Green(), ...)

If expression is only for one and transpose the column then could use some thing like below

If(Match(Field, 'Value', Expression1) = Match(Field, 'Value', Expression2), Green(), ...)

Re: How to mark equal values in rows in Green colour

vardhancse — Mon, 04 Sep 2017 04:50:16 GMT

Hi,

for example lets take column(4) and column(5) are last 2 columns.

Chart Properties->Expressions->Expression

Expand(+)->Back ground colour

Condition:

IF(Column(4)=Column(5),Green(),Red())

**Always you last two expressions should be in 4 and 5 order if not the back ground color will not workout.

Re: How to mark equal values in rows in Green colour

Anonymous — Mon, 04 Sep 2017 07:18:35 GMT

sir i want if there exists any value which is equal in last two columns it should be marked as green(for eg:- grade A in both the columns should be shown in green background color and whereas others if not equal in red

Re: How to mark equal values in rows in Green colour

Anil_Babu_Samineni — Mon, 04 Sep 2017 07:21:22 GMT

Please share some sample application?

Re: How to mark equal values in rows in Green colour

vardhancse — Mon, 04 Sep 2017 07:25:38 GMT

In background color condition, IF(Column(4)=Column(5),Green(),Red())

Give required condition

Or else can share some sample app , will try and will let you know

Re: How to mark equal values in rows in Green colour

Anonymous — Mon, 04 Sep 2017 07:42:32 GMT

Re: How to mark equal values in rows in Green colour

Anil_Babu_Samineni — Mon, 04 Sep 2017 07:44:50 GMT

Yes, You could use similar way

If(Column(3) = Column(2) or Column(3) = Column(1) , Green(), Red())

Re: How to mark equal values in rows in Green colour

Anonymous — Mon, 04 Sep 2017 08:45:36 GMT

sir I want this garde A should reflect in reen because both the values of last column are eual and its not functioning why?

please help