Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
khaycock
Creator
Creator

Conditional Formatting Straight Table

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.

cond.PNG

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

Thanks

1 Solution

Accepted Solutions
qlikviewnovice
Specialist II
Specialist II

Hi

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!!

View solution in original post

4 Replies
Anonymous
Not applicable

just set the color condition for every dimension

and expression

in use

khaycock
Creator
Creator
Author

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

qlikviewnovice
Specialist II
Specialist II

Hi

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!!

View solution in original post

Anonymous
Not applicable

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...