topic Custom color for expression columns in QlikView

Custom color for expression columns

montubhardwaj — Tue, 03 Apr 2012 22:24:08 GMT

Hello Everyone,

Hope you are fine. I have a scenarion in which I want to have custom colors for different expression columns. Is there any way to do it? I want this in a Pivot table.Please let me know. Below is sample given.

Regards,

Sharma

Re: Custom color for expression columns

Sokkorn — Wed, 04 Apr 2012 02:37:52 GMT

Hi Sharma,

Let do this way:

1. Settings-> User preference -> Design -> Check "Always Show design menu item"

2. Right click on chart -> "Custome format cell"

See the sample attached file.

Do let me know if you are looking for this one.

Regards,

Sokkorn

Custom color for expression columns

montubhardwaj — Wed, 04 Apr 2012 05:24:04 GMT

Hi Sokkorn,

Thanks for your time and looking into this. But this way, the color for all the expression column will change if change color for any of expression column. In my scenario, I want to have different colors for different expression columns. As shown in my example, Exoression Column1 should be Yellow, Exoression Column2 should be Blue and Exoression Column3 should be Green. Is this doable ?

Thanks.

Sharma

Custom color for expression columns

Wed, 04 Apr 2012 05:55:59 GMT

Hi Sokkorn Cheav ,

Thanks for beautifull Explanation was looking for it

Good !!!

Warm regards,

Anant Dubey

Re: Custom color for expression columns

Sokkorn — Wed, 04 Apr 2012 06:35:02 GMT

Hi Sharma,

I'm not sure whether you check my attached sample file yet. By the way I think we can do it using my scenario.

Regards,

Sokkorn

Custom color for expression columns

montubhardwaj — Wed, 04 Apr 2012 15:27:09 GMT

Hi Sokkorn,

You can have different colors for dimenstion columns and expression columns and I agree with you. But my problem is little different here.

I have 5 dimenstion columns and 8 expression columns.I want different different colors for expression columns only( i.e different color for each 0f 8 expression column)a. I am not caring for dimension column's color and it can be anything. Please let me know if I am missing something here.

Regards,

Sharma

Re: Custom color for expression columns

marcelo_7 — Fri, 21 Sep 2012 10:47:21 GMT

I'm looking to do the same thing but when rightclicking and selecting "Custom Format Cell" the dropbox "Apply change to" only gives the option "All dimensions"

Re: Custom color for expression columns

Fri, 21 Sep 2012 11:26:47 GMT

Hi Sharma,

I would suggest you to make use of Expressions Background Color option to mention different colors expression column level wise.

Hope this resolves your color issue.

Thanks,

Kumar

Re: Custom color for expression columns

marcelo_7 — Fri, 21 Sep 2012 11:51:33 GMT

The expression doesn't color the headers, only the fields below. In my case and in Sharmas case we want to change the color of the header only. Sharma has an image of excel in her post, that's what I would like it to look like too.

Cheers!

Re: Custom color for expression columns

Thu, 13 Jun 2013 14:50:19 GMT

How do you manage to change only 1 header?

When I change 1 header, all headers are automaticaly changed.

I have "Apply change to", but I can't change it, it's always "All dimensions".

I tried with QV 10 SR 6 and QV 11 SR 2.

Re: Custom color for expression columns

Thu, 13 Jun 2013 19:59:48 GMT

Hello,

If I am understanding what you are asking, you can do it easily with the Visual Cues...

This is a pivot table object... you can set the background color for the text data... which is basically the column headings.

Re: Custom color for expression columns

Thu, 13 Jun 2013 20:01:44 GMT

I haven't figured out how to change the dimension column header colors though... just the expressions...

Re: Custom color for expression columns

partner_enginee — Tue, 12 Nov 2013 11:31:27 GMT

Isn't it enough to clone dimensions to new expressions and give the Presentation flag "Hide from display" (or "Do not show", something like this) to dimension columns ?