topic Re: How to Change Chart background grid color in QlikView

How to Change Chart background grid color

Thu, 24 Oct 2013 19:28:56 GMT

How to Change Chart background grid color, the grid lines I can do it but the bricks color can't change

Re: How to Change Chart background grid color

Anonymous — Thu, 24 Oct 2013 19:48:47 GMT

If by bricks you mean the bars, then go to the Expression tab and click the + to left of the expressions and for Background Colour give a definition using a colour function like Red() or Blue().or rgb(222,55,99)...........

If I have misunderstood what you are after then please clarify your question.

Best Regards, Bill

Re: How to Change Chart background grid color

Thu, 24 Oct 2013 20:00:10 GMT

Thanks for reply, yea but as I show in attachment I need two color, like dark at the bottom and light at top.

Appreciate all the help. Also if u can help me this, in list box I am trying to change the background to transparent can’t find the command or color..

Thanks

Re: How to Change Chart background grid color

Anonymous — Thu, 24 Oct 2013 20:04:46 GMT

I think the bricks is the grid style.

The color does change, it is just not bright, a sort of "gray-ish". I can see the difference between red and blue, not much of green.

In any case, I'd rather avoid bricks and tiles. They maybe look "cool" but take more resources. For example, print chart as PDF when the grid is bricks, tiles, and simple lines - the PDF size is quite different.

(I have to add that last time I used it was many versions ago, maybe it is better now.)

Regards,

Michael

Re: Re: How to Change Chart background grid color

rustyfishbones — Thu, 24 Oct 2013 20:08:03 GMT

Do you mean like this

Re: How to Change Chart background grid color

Thu, 24 Oct 2013 20:09:46 GMT

Thanks for reply, it don’t have to b brick can b plain, just want two color as I show in sample, some how trying hard to change that, missing some command

Thanks

mazhar

Re: Re: How to Change Chart background grid color

rustyfishbones — Thu, 24 Oct 2013 20:12:53 GMT

with regard to the list box background, you may need to change the Selection style as LED Check Boxes

you can then chosse the Background button as seen below and set the color to 100% transparent

Re: How to Change Chart background grid color

Thu, 24 Oct 2013 20:21:10 GMT

Bundle of thanks, list chart background works, still looking for chart grids, not the line color but bricks color.

thanks

Re: How to Change Chart background grid color

Anonymous — Thu, 24 Oct 2013 20:26:54 GMT

I guess this is what you want...

In chart properties, tab Style, find Plot Are Background Style, and change it from Minimal to Frame or Shadow.

Apply and go to Colors tab. Click Plot Area, and use one color gradient or two color gradient. Choose colors you want.

Did I guess it right this time?

Edit: attached

Re: How to Change Chart background grid color

rustyfishbones — Thu, 24 Oct 2013 20:27:38 GMT

I dont understand the bricks color, see the image below, option 1 or 2

Re: How to Change Chart background grid color

Thu, 24 Oct 2013 20:34:58 GMT

optoion 1

Re: How to Change Chart background grid color

rustyfishbones — Thu, 24 Oct 2013 20:37:17 GMT

ok option 1, you need to follow what Michael has said above

I guess this is what you want...

In chart properties, tab Style, find Plot Are Background Style, and change it from Minimal to Frame or Shadow.

Apply and go to Colors tab. Click Plot Area, and use one color gradient or two color gradient. Choose colors you want.

Did I guess it right this time

Re: How to Change Chart background grid color

Thu, 24 Oct 2013 20:52:58 GMT

Guys Bundle of thanks…one more obstacle in list box I can’t change text color to white, try Font but can’t find any other command

Really Appreciate ur help

thanks

Re: How to Change Chart background grid color

rustyfishbones — Thu, 24 Oct 2013 21:45:10 GMT

when you choose LED Check boxes, you need to close the list box properties, open the porperties again and the option to change the font color will be available

I done a video on this on youtube

go to Youtube and type the following

Qlikview ListBox Hide Excluded & Change Font Color by RFB 41

Re: How to Change Chart background grid color

rustyfishbones — Thu, 24 Oct 2013 21:45:46 GMT

Mazhar please mark the correct and helpful answers to help other users find wht they need also

Re: How to Change Chart background grid color

offjunior — Thu, 24 Oct 2013 22:27:31 GMT

Good evening friends!

Follow the steps below in the images you able to change the background color of the drawing area of the chart. If you answered that answer, do not forget to mark as correct answer so others can use the same help. If not so, sends an image of the chart you want to change.

Hugs!

Re: How to Change Chart background grid color

Mon, 28 Oct 2013 20:11:27 GMT

Hi Alan

sorry to bother u for some reason I cannot post my question in community board, who I can contect

thanks