topic Re: how to color ONLY the Dimension headers in QlikView

how to color ONLY the Dimension headers

Wed, 07 May 2014 11:08:21 GMT

Hi, I need to color the bg ONLY of the dimension headers...how can I do it???

Re: how to color ONLY the Dimension headers

its_anandrjs — Wed, 07 May 2014 11:11:19 GMT

Use Custome Cell Formats for this check the settings

Go to User Preferences >> Design >> Check the Always Show Design Menu Items

and then right click on the chart header to change the background color.

Re: how to color ONLY the Dimension headers

Wed, 07 May 2014 11:14:49 GMT

nope guys, I have already done that and it colors ALL the headers! I want to color only the two headers you can see in the picture...

Re: how to color ONLY the Dimension headers

sujeetsingh — Wed, 07 May 2014 11:18:26 GMT

Use custom format cell option .

To set this option in your doc

Go to>>Setting>>User Preferences>>Design Tab>>Always Show Design Menu

Re: how to color ONLY the Dimension headers

sujeetsingh — Wed, 07 May 2014 11:19:30 GMT

Use trick Take a Text Box with same text and Size and just place it with layout as top and not moveable.

Re: how to color ONLY the Dimension headers

Wed, 07 May 2014 11:22:11 GMT

sujeetsingh is there another way to color specif headers? I cannot add other elements on the sheet...

Re: how to color ONLY the Dimension headers

Wed, 07 May 2014 11:33:33 GMT

Use Grid (Ctrl+G) to enable it. Then right click on the table header and select Use Custom Format Cell.

In that you can change the background colour. Hope this helps

Re: how to color ONLY the Dimension headers

Wed, 07 May 2014 11:39:06 GMT

hi irene

you want color only for the dim or for the values also

Re: how to color ONLY the Dimension headers

Wed, 07 May 2014 11:40:57 GMT

just the bg of the dimensions, as in the picture I posted. I don't need to color any specific value of those dimensions...

Re: how to color ONLY the Dimension headers

rsdhavle — Wed, 07 May 2014 11:41:20 GMT

Click CTRL + G it will activate grid on the application. Right click on dimension header for which you want to change a color. Click on custom format cell. Then in background color change the color you want

Re: how to color ONLY the Dimension headers

Wed, 07 May 2014 11:41:27 GMT

hi go u can click on dimension and go for background color and give expression

i have given like this for my dim ....

=IF(MonthSelect=Month,Yellow(),White())

Re: how to color ONLY the Dimension headers

Wed, 07 May 2014 11:44:01 GMT

hey you can to expression and tab and click on label and go to background colour and write a expression wat u want

Re: how to color ONLY the Dimension headers

Wed, 07 May 2014 11:44:19 GMT

I have already done that, but it colors ALL the headers! I need only two of them...

Re: how to color ONLY the Dimension headers

Wed, 07 May 2014 11:45:07 GMT

not sure it would work, I must always change the selection, I was looking for something static, like in excel when you color a cell no matter the formula in it...

Re: how to color ONLY the Dimension headers

Wed, 07 May 2014 11:46:47 GMT

Mvrchowdary Rao I was considering the formula, but a static one, without "if" conditions...

Re: how to color ONLY the Dimension headers

Wed, 07 May 2014 11:51:34 GMT

you can try with text object in my prof i did with text obj