topic Re: Pivot Table Clour/Font formating in QlikView

Pivot Table Clour/Font formating

anuradhaa — Wed, 25 Nov 2020 16:16:04 GMT

Please see attache image.

I want to remove gray fill in column headers and want to how how to enable bold in Totals and disable it in subtotals.

Thanks

Re: Pivot Table Clour/Font formating

arulsettu — Fri, 17 Jun 2016 06:31:31 GMT

have you tried custom format cell by right clicking o the cell

Re: Pivot Table Clour/Font formating

Anil_Babu_Samineni — Fri, 17 Jun 2016 06:32:39 GMT

You want some color Right, Tell me Which Color?

Re: Pivot Table Clour/Font formating

Anonymous — Fri, 17 Jun 2016 06:34:59 GMT

formatting in pivot table....urgent

Check above link

Re: Pivot Table Clour/Font formating

anuradhaa — Fri, 17 Jun 2016 06:35:37 GMT

I want to know how "gray" come as default. I want to change that default colur to white in all my charts.

Re: Pivot Table Clour/Font formating

Anil_Babu_Samineni — Fri, 17 Jun 2016 06:38:22 GMT

FYI..

Re: Pivot Table Clour/Font formating

Anonymous — Fri, 17 Jun 2016 06:39:49 GMT

Check the link which i have posted. you can find solution there

Re: Pivot Table Clour/Font formating

vikasmahajan — Fri, 17 Jun 2016 06:46:44 GMT

Press this button and Right click chart -> Select Custom Format Cell

formatting in pivot table....urgent

Here you can do formatting.

Vikas

Re: Pivot Table Clour/Font formating

anuradhaa — Fri, 17 Jun 2016 06:46:58 GMT

I know it can be done using Custom format cells, what i want to set deafult Background colur in custom for mat cells.

Whne we go to custom format cells there are gray cells and it was set as default.

Re: Pivot Table Clour/Font formating

susovan — Fri, 17 Jun 2016 06:50:44 GMT

Hi Anuradha,

Will you want to like this?

Re: Pivot Table Clour/Font formating

Anonymous — Fri, 17 Jun 2016 06:50:47 GMT

As you said gray color default in user preferences. That is something like inbuilt. If you want to change you have to do these steps.

Re: Pivot Table Clour/Font formating

Anil_Babu_Samineni — Fri, 17 Jun 2016 06:54:59 GMT

Kishore,

Might be she want to change BG for Dimension. Anuradha, Please Confirm here...

PF my Attachment

Re: Pivot Table Clour/Font formating

anuradhaa — Fri, 17 Jun 2016 06:56:03 GMT

I know this Can be done using "Custom Format Cells" and how to use that. But when i do that i want to do it Cell by Cell/ Table by Table.

But when we create pivot Table the header colurs are set to "gray" by defalt by qlikview. So that i want to know is is it possible to chnage this default "Gray". Then in each time i create a report it shows the changed colur

Re: Pivot Table Clour/Font formating

anuradhaa — Fri, 17 Jun 2016 06:56:32 GMT

I know this Can be done using "Custom Format Cells" and how to use that. But when i do that i want to do it Cell by Cell/ Table by Table.

Re: Pivot Table Clour/Font formating

Anonymous — Fri, 17 Jun 2016 06:59:52 GMT

Yes i hope every time, you create an Object Pivot table, you have to go to custom format cells and change it..

No other go..

By default it will be gray, whenever you create.

Re: Pivot Table Clour/Font formating

Anil_Babu_Samineni — Fri, 17 Jun 2016 07:03:12 GMT

Anuradha,

I don't think so it will be work or not. But, Try kishore way. Before that please confirm me which color you want to change BG either Dimension / Expression?

You want to change BG for Dimension or What...

Re: Pivot Table Clour/Font formating

Anonymous — Fri, 17 Jun 2016 07:04:25 GMT

Anil,

Check your qvw once please.

I think it doesn't have any code for the dimension on their bg color.

I don't know where those colors came from.

Re: Pivot Table Clour/Font formating

arulsettu — Fri, 17 Jun 2016 07:06:43 GMT

AFAIK there is no option to change default color. you need to change it every time

Re: Pivot Table Clour/Font formating

Anonymous — Fri, 17 Jun 2016 07:10:27 GMT

Hi Anuradha,

Use QlikView templates.

Regards!

Re: Pivot Table Clour/Font formating

anuradhaa — Fri, 17 Jun 2016 07:11:39 GMT

Can you share how to do this?