topic Re: How to apply text color based on row wise with two fields comparition in qlikview in QlikView

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

satheshreddy — Wed, 27 Sep 2017 10:53:28 GMT

Hi Experts,

Can any one give ideas for the below requirement.

I have data like below.

Count of Sep

Count of Aug

I need output like below.

Count of Sep

Count of Aug

Regards

Sathish

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

prma7799 — Wed, 27 Sep 2017 11:06:01 GMT

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

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

prma7799 — Wed, 27 Sep 2017 11:14:12 GMT

Like this you want

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

satheshreddy — Wed, 27 Sep 2017 11:46:50 GMT

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

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

Anil_Babu_Samineni — Thu, 28 Sep 2017 05:30:53 GMT

Can this works?

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

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

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

avinashelite — Thu, 28 Sep 2017 05:37:14 GMT

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())

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

its_anandrjs — Thu, 28 Sep 2017 05:38:08 GMT

What is condition for high range that you mention.

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

Anil_Babu_Samineni — Thu, 28 Sep 2017 05:47:37 GMT

I added these 2 and working

Expression 1 Text color

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

Text format

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

Expression 2 Text color

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

Text format

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

And output i got it like

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

satheshreddy — Thu, 28 Sep 2017 05:47:41 GMT

Hi Anil,

Thanks a lot its working awesome.

Regards

Sathish