topic Re: Chart Colors in QlikView

Chart Colors

Thu, 07 Apr 2016 23:36:11 GMT

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?

Re: Chart Colors

swuehl — Thu, 07 Apr 2016 23:42:43 GMT

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

Re: Chart Colors

Thu, 07 Apr 2016 23:44:08 GMT

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

Re: Chart Colors

sunny_talwar — Fri, 08 Apr 2016 00:02:44 GMT

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

Re: Chart Colors

Fri, 08 Apr 2016 00:04:11 GMT

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

Re: Chart Colors

sunny_talwar — Fri, 08 Apr 2016 00:08:28 GMT

May be a sample with dummy data or Preparing examples for Upload - Reduction and Data Scrambling

Re: Chart Colors

kkkumar82 — Fri, 08 Apr 2016 10:59:00 GMT

Hi,

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

Hope it helps

Re: Chart Colors

flipside — Fri, 08 Apr 2016 11:36:56 GMT

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.

Re: Chart Colors

agustinbobba — Fri, 08 Apr 2016 13:52:02 GMT

Hi Trung,

Try this:

Best regard,

Agustin

Re: Chart Colors

Fri, 08 Apr 2016 16:31:44 GMT

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.