Table Style

[master_student]

Hello freinds,

I have a question as usual

I want to use the same style of a table in one of my dashbords (not created by me).

Below is the styple I would like to get:

The problem is that when I use this tool, , I get this result :

Any idea please?

Thanks a lot

[sunny_talwar]

Seems like the bottom table is a straight table and the above one is Pivot. Which formatting are you trying to copy?

[krishnacbe]

Hi,

The first chart is Pivot table and the second chart is staright table. Please change the chart type and check.

Check the dimensions and measures used in first and second are same.

Regards

Krishnapriya

[master_student]

I would like to  copy the background color of the titles. ect

[krishnacbe]

You cannot format using format painter I hope. Please use Custom format cell option.

[master_student]

how please.

Thanks

[tamilarasu · Accepted solution]

You can use custom format cell to copy the existing background color and text color.

If you do't know about custom format cell, below link might be helpful.

Custom formatting table cells - The Qlik Fix! The Qlik Fix!

[master_student]

Thanks. I didn't know that before

[tamilarasu]

If you are not sure how to copy the background color or text color, please follow the below steps.

1.I hope you read the above link. After enabling the custom format cell option, go to your pivot table and right click on the back ground color box. Now, select copy option in the pop up menu.

2. Now go to your straight table and select custom format cell option. Right click and select paste option. You can do the same for text color.

Hope this helps.

[master_student]

Thank you