Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Who to change de color of those bars in a grafic chart that's under some target?

I need to know who to change de color of those bars in a grafic chart that's under some target as, for exemple, the monthly sales target for each vendor.

3 Replies
Not applicable

Who to change de color of those bars in a grafic chart that's under some target?

Hi,

To define colors to change according to a target, you need to go to Chart properties --> Visual Cues --> Select the expression and specify your target in Upper and/or Lower. Select your color appropriately.

Sample_Snap.png

However, this probably only works for a straight table and a pivot table. Is that what you are looking for?

Regards,

-Khaled.

deepakk
Valued Contributor III

Re: Who to change de color of those bars in a grafic chart that's under some target?

HI,

In addition to the solution provided by khaled, you can also change the color in the expression tab by adding the condition like

if (Target <0,red(), if(target >0 and target <50 , rgb(100,132,143),rgb(222,65,66)))

You need to add the condition in the defination tab on right.

Attach is the screen shot for the same.

Deepak

chandashok
Contributor III

Re: Who to change de color of those bars in a grafic chart that's under some target?

Hi

Hope the attached file will be used to solve your doubt

Regards

Ashok