Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

paulyeo11
Valued Contributor II

How to make my chart bar turn yellow when GP% less then 15% ?

Hi All
May i know how to make my chart display as below :-
1. if GP > 30% Dark Green
1. if GP > 15% <30%  Light Green
1. if GP < 15% light Yello
Now all bar are black
Paul
1 Solution

Accepted Solutions
paulyeo11
Valued Contributor II

Re: How to make my chart bar turn yellow when GP% less then 15% ?

Hi Sir

Very smart why. Thank it work.now.

Paul

3 Replies
paulyeo11
Valued Contributor II

Re: How to make my chart bar turn yellow when GP% less then 15% ?

Hi All

My QV Doc

mvanlutterveld
Contributor II

Re: How to make my chart bar turn yellow when GP% less then 15% ?

Hi Paul,

I changed the name of your GP% expression to: GP%. In the Background Color attribute of the Sales expression I entered the following nested if:

If(GP% > 0.3,rgb(0,128,0)

  ,If(GP% < 0.15, RGB(255,255,98), RGB(0,255,0))

  )

This resulted in the following:

Capture.PNG

Is this what you're looking for?

Cheers,

Michiel

paulyeo11
Valued Contributor II

Re: How to make my chart bar turn yellow when GP% less then 15% ?

Hi Sir

Very smart why. Thank it work.now.

Paul