topic Re: Conditional Highlighting in QlikView

Conditional Highlighting

Wed, 16 May 2012 12:17:02 GMT

Hi,

I'm currently trying to highlight a single column on the x axis of a bar graph. The criteria for highlighting is dependent on the value of the x axis though, not the outcome of the expression on the y axis.

What I've done for the moment is created an input box that defines the variable 'OrgName'. If that matches the name of the organisation on the x axis, I'd like it to highlight. I've tried if([Org Name]=Orgname,red() but to be honest, I'm a complete rookie with Qlikview, so not entirely sure what I'm doing.

Any help would be much appreciated!

Thanks,

Dan

Re: Conditional Highlighting

john_duffy — Wed, 16 May 2012 12:37:55 GMT

Hi Dan.

You can expand the expression on the Expressions tab and set the Background and Text colours.

See the attached example where I change the colour to red if the Dept = 'IT'.

Hope this helps.

John.

Re: Conditional Highlighting

john_duffy — Thu, 24 May 2012 19:29:12 GMT

Hi Dan.

Did this solution resolve your issue?

John.

Re: Conditional Highlighting

Fri, 25 May 2012 14:41:33 GMT

Hi John,

Sorry for not replying sooner! The project I was working on has temporarily been put on hold. At the time, I looked at the QV file and couldn't find what you mentioned in there. I tried replicating the solution myself in what I was working on, but again to no avail.

When I come back to it, I'll spend a little more time trying to get it working again. Thank you for your response though!

Best,

Dan