topic Re: Horizontal Dimension Color in Pivot table in QlikView

Horizontal Dimension Color in Pivot table

Wed, 25 Nov 2020 16:16:04 GMT

Greetings

Is it possible to change the color of the horizontal dimension in a pivot table.

Please find attach the qvw file.

Thanks

Re: Horizontal Dimension Color in Pivot table

Chanty4u — Thu, 17 Mar 2016 09:51:32 GMT

did u tried custom format cell?

Re: Horizontal Dimension Color in Pivot table

tamilarasu — Thu, 17 Mar 2016 09:54:09 GMT

Hi,

Right click on the chart and select custom format cell option. You can format both dimension and expression cells in the displayed window.

Re: Horizontal Dimension Color in Pivot table

Chanty4u — Thu, 17 Mar 2016 09:54:19 GMT

is this?

Re: Horizontal Dimension Color in Pivot table

Chanty4u — Thu, 17 Mar 2016 09:55:18 GMT

sry

Re: Horizontal Dimension Color in Pivot table

jonathandienst — Thu, 17 Mar 2016 09:55:49 GMT

Right click on he values and select "Custom Format Cell". Select the font and background colours from the dialog and then in "Apply change to", choose Current Dimension.

Re: Horizontal Dimension Color in Pivot table

sunny_talwar — Thu, 17 Mar 2016 09:55:52 GMT

Something along these lines?

Used Custom Format Cell as mentioned by Chanty 4u

Re: Horizontal Dimension Color in Pivot table

avinashelite — Thu, 17 Mar 2016 09:59:06 GMT

check the Design Grid option>from Design tool bar (to view the tools bar go to view tool>design)

and then right click custom format cell appears ...chose the color according to your requirement

Re: Horizontal Dimension Color in Pivot table

Kushal_Chawda — Thu, 17 Mar 2016 10:00:49 GMT

Go to Settings->User Preferences ->Design->check the box "Always Show Design Menu Options"

Now right click on the Pivot table and click Custom Format Cells. Here you can select any cell and change the color.

Re: Horizontal Dimension Color in Pivot table

Thu, 17 Mar 2016 10:04:27 GMT

Thank You all for your quick response.

Re: Horizontal Dimension Color in Pivot table

g23 — Fri, 11 Sep 2020 14:35:58 GMT

is it possible to do this in qlik sense?