Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

How to highlight an expression based on another column value?

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.

 

if

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

Please advise,

Thanks,

Saravanan

1 Solution

Accepted Solutions
Highlighted
sergey_maka8
Valued Contributor

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

color.pngTry to specify your color condition in YourExpression\Background Color

See an example attached.

3 Replies
Highlighted
sergey_maka8
Valued Contributor

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

color.pngTry to specify your color condition in YourExpression\Background Color

See an example attached.

Not applicable

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

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

sergey_maka8
Valued Contributor

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

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

Community Browser