topic Re: Conditional Formatting Straight Table in QlikView

Conditional Formatting Straight Table

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

Hey,

Is it possible to conditional format a row depending on another field? I have a Straight table where I need to colour a row depending on a specific field. So if Order Constraint is At Risk, I need the row to be yellow, if it is Blocked, I need it red and if its null, green.

What is the best way to do this, if possible?

Thanks

Re: Conditional Formatting Straight Table

Anonymous — Mon, 05 Jun 2017 09:33:38 GMT

just set the color condition for every dimension

and expression

in use

Re: Conditional Formatting Straight Table

khaycock — Mon, 05 Jun 2017 09:39:37 GMT

I've tried with an if statement but couldnt get that to work

Re: Conditional Formatting Straight Table

Anonymous — Mon, 05 Jun 2017 09:41:56 GMT

For your Constraint Count expression>Expand your expression>Background Color:If(OrderConstraint='At Risk',RGB(255,255,0),If(OrderConstraint='Blocked',RGB(255,0,0),RGB(0,255,0)))

Hope it helps!!

Re: Conditional Formatting Straight Table

Anonymous — Mon, 05 Jun 2017 09:42:47 GMT

could you create a sample please...

My first guess is that the OrderConstraint isn't distinct within your dimension hierarchy...

Then you would get null() as return value...

But as I said, I need some sample data...