Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

How to make my chart appear 3 color ? Now only 2 color

Hi All

Now my Bar chart if more then 30% it turn light Blue. below 30% bar color Blue.

Now i like to make 2013 Bar now Blue change to red color ? when GP % below 20% Bar color change to red.

I will enclosed my QV Doc in my next posting

Paul

26 Replies
settu_periasamy
Master III
Master III

No problem.

rajeshforqlikvi
Creator
Creator

Hi ,

For the bar chart left axis is there and for the line chart right axis is there in your report.

Now you want the bar chart has to reflect on right axis basis. do you have any relation between

bar & line chart if yes then it will be easy to write the back ground color condition.

Regards

Rajesh Kumar

paulyeo11
Master
Master
Author

Hi Settu

it is possible for change the script to have 4 color ?

Paul

settu_periasamy
Master III
Master III

Yes, what is the criteria for 4th one?

paulyeo11
Master
Master
Author

Hi Rajesh

I am not quite understand what you mean ?

Paul

paulyeo11
Master
Master
Author

If GP % less then 15% Black Color

Sent from my iPhone

settu_periasamy
Master III
Master III

Try this..

If(GP% > 0.3,Yellow(),

  If(GP% < 0.15,Black(),

  If(GP% < 0.2, Red(), Green())))

paulyeo11
Master
Master
Author

Hi Settu

Can you go back to the org script on 3 Color , this time add a new condition if GP% > 33 % Color = Black

As previous one less then 15% Black Color your script is not work , I can not explain to you why.

Paul

Sent from my iPhone

settu_periasamy
Master III
Master III

I did test, it is working for me..

paulyeo11
Master
Master
Author

You can adjust the GP% and see 4 Color ?

Sent from my iPhone