topic Re: Table Style in QlikView

Table Style

master_student — Thu, 16 Jun 2016 13:22:09 GMT

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

Re: Table Style

sunny_talwar — Thu, 16 Jun 2016 13:25:46 GMT

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

Re: Table Style

krishnacbe — Thu, 16 Jun 2016 13:25:58 GMT

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

Re: Table Style

master_student — Thu, 16 Jun 2016 13:28:52 GMT

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

Re: Table Style

krishnacbe — Thu, 16 Jun 2016 13:39:53 GMT

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

Re: Table Style

master_student — Thu, 16 Jun 2016 13:40:35 GMT

how please.

Thanks

Re: Table Style

tamilarasu — Thu, 16 Jun 2016 13:40:47 GMT

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!

Re: Table Style

master_student — Thu, 16 Jun 2016 13:57:23 GMT

Thanks. I didn't know that before

Re: Table Style

tamilarasu — Thu, 16 Jun 2016 13:59:58 GMT

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.

Re: Table Style

master_student — Thu, 16 Jun 2016 14:18:27 GMT

Thank you

Re: Table Style

tamilarasu — Thu, 16 Jun 2016 14:30:13 GMT

You are welcome, Wieme.