topic How to highlight an expression based on another column value? in QlikView

How to highlight an expression based on another column value?

Thu, 08 May 2014 04:01:35 GMT

Dear Experts,

We have a scenario like, when we input item#, the bar chart output shows all those vendors supplying this item. But only one vendor can be active at a time. We would like to highlight active vendor in GREEN color and the others should be in 'WHITE' color.

Active/Inactive vendor is controlled by a field 'ASL_COMMENTS'. Only for active suppliers this field will be NULL.

We tried with below expression in the colors tab. But it's not working.

(isnull(ASL_COMMENTS), green(),white())

Please advise,

Thanks,

Saravanan

Re: How to highlight an expression based on another column value?

SergeyMak — Thu, 08 May 2014 04:42:29 GMT

Try to specify your color condition in YourExpression\Background Color

See an example attached.

Re: Re: How to highlight an expression based on another column value?

Thu, 08 May 2014 05:02:37 GMT

Hi Sergey,

It's working now. Thanks a lot.

But still have a concern. The color of the line also getting changed along with the bar.

Is is possible to change bar color only without touching the line color?

Thanks,

Saravanan

Re: Re: How to highlight an expression based on another column value?

SergeyMak — Thu, 08 May 2014 06:06:33 GMT

So you can use two separate expressions:

one for bars and one for lines.

In the second just don't use expression for the background