How to apply text color based on row wise with two fields comparition in qlikview

[satheshreddy]

Hi Experts,

Can any one give ideas for the below requirement.

I have data like below.

NO	Count of Sep	Count of Aug
1	12	84
2	96	02
3	12	78

I need output like below.

NO	Count of Sep	Count of Aug
1	12	84
2	96	02
3	12	78

Regards

Sathish

[prma7799]

Go to Expression >> Text color >> write your codition

[prma7799]

Like this you want

[satheshreddy]

HI P M,

Thanks For your response,

here I need what ever we have high count that all are need to see in Green Low Count I need to see red.

Note: here we need to calculate Row wise with two columns.

Regards'

Sathish

[Anil_Babu_Samineni]

Can this works?

Text color - If(Column(1) < Column(2), Green(), Red())

Format - If(Column(1) < Column(2), '<B>', '<B>')

[avinashelite]

try like this

Text color -

for first expression

If(Column(1) > Column(2), Green(), Red())

for Second expression

If(Column(2) > Column(1), Green(), Red())

[its_anandrjs]

What is condition for high range that you mention.

[Anil_Babu_Samineni · Accepted solution]

I added these 2 and working

Expression 1 Text color

If(Column(1) < Column(2), Red(), Green())

Text format

If(Column(1) < Column(2), '<B>', '<B>')

Expression 2 Text color

If(Column(1) > Column(2), Red(), Green())

Text format

If(Column(1) < Column(2), '<B>', '<B>')

And output i got it like

[satheshreddy]

Hi Anil,

Thanks a lot its working awesome.

Regards

Sathish