Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Chart Colors

I am trying to make my bar charts all  one consistent color. I would like to have all my bars to have RGB(21,71,124).  I created a  variable called  vBarChartColor=RGB(21,71,124) . I've added the variable into the Background Color for all my expression in the chart.  It has been working find until my recent reolad. After my recent reload, itt is using the colors that are in the 'Colors' tab.

Any ideas on how I can fix this?

BackgroundColor.pngchart.png

9 Replies
swuehl
MVP
MVP

Hard to tell from looking at your screenshot. Have you checked that your variable is still showing the RGB value?

Not applicable
Author

Yes, my variable is still holding the value of RGB(21,71,124).

sunny_talwar

Would you be able to share a sample where it isn't working?

Not applicable
Author

Do you mean the qvw?  If so, I wont be able to share the qvw.

sunny_talwar

kkkumar82
Specialist III
Specialist III

Hi,

Is multicolor option in colors tab off, check off multicolor in color tab.

Hope it helps

flipside
Specialist II
Specialist II

Using your method, you may need to include an '=' sign in the variable.

I.e. "=RGB(21,71,124)" and not just "RGB(21,71,124)".

Has the = sign been lost somewhere.

agustinbobba
Partner
Partner

Hi Trung,

Try this:

a.png

b.png

Best regard,

Agustin

Not applicable
Author

Thanks Agustin for your response.   Making the expression a dollar sign expansion $(variable) works.

I understand what is happening here. Initially, when I was testing, I created this variable in the qvw app.  However, after I got it to work, I moved the variable outside of the app and stored in it excel.  From excel, when I reload the app, I bring in all my variables that are stored in excel.  What I've learned is,  I needed an dollar sign expansion when I am using a variable.