topic Re: Re: Re: Regarding Plot Color to set Background color in QlikView

Regarding Plot Color to set Background color

neetu_singh — Wed, 08 Jan 2014 14:12:21 GMT

Dear All,

I just want to set the background color of a bar chart on the basis of yearmonth as mention below:

Can anybody help on this.

Re: Regarding Plot Color to set Background color

rajeshvaswani77 — Wed, 08 Jan 2014 14:16:34 GMT

Hi Neetu,

You could go to the expressions then click on the + sign --> background color --> and then give if condition to check the months/year and mention the color using the RGB function.

Hope this helps.

thanks,

Rajesh Vaswani

Re: Regarding Plot Color to set Background color

Wed, 08 Jan 2014 14:20:10 GMT

Unfortunately changing the background color of the expression will only change the color of the bars/line. As far as I know this is not possible in QV. Interested to see if anyone can figure it out.

Re: Regarding Plot Color to set Background color

neetu_singh — Wed, 08 Jan 2014 14:20:14 GMT

Hi Rajesh,

have tried the same but its not working as have two dimension one is yearmonth & second is state. so if i set the background color as mention by you it will change the color of lines not the background.

Re: Re: Regarding Plot Color to set Background color

Anonymous — Wed, 08 Jan 2014 18:10:58 GMT

Neetu

Does the attached qvw give you food for thought ?

Best Regards, Bill

Re: Re: Re: Regarding Plot Color to set Background color

rwunderlich — Wed, 08 Jan 2014 19:26:40 GMT

Here's a variation on your idea Bill that handles an variable number of years.

-Rob

http://masterssummit.com

http://robwunderlich.com

Re: Regarding Plot Color to set Background color

neetu_singh — Fri, 10 Jan 2014 07:01:14 GMT

Hi Rob,

I want the same but the problem is in my chart there are two dimension because of that its not working.

please help.

Regards

Neetu

Re: Regarding Plot Color to set Background color

rwunderlich — Fri, 10 Jan 2014 19:04:54 GMT

Please show how you would want the second dimension to display. I don't see it in your original post.

-Rob