topic table expression background calculate color tab & cell in QlikView

table expression background calculate color tab & cell

wenkew186 — Tue, 12 Nov 2013 09:16:34 GMT

hi experts,

i have a problem with when i set the expression background calculate color the tab will with the cell same. can i make the tab color different with cell? my version is 9.0. pls check the picture and pls help me thanks very much!

kevin.

Re: table expression background calculate color tab & cell

bbi_mba_76 — Tue, 12 Nov 2013 09:57:44 GMT

Hi,

If I'm not wrong, in the pivot table the expression header take the background of the first cell.

Re: table expression background calculate color tab & cell

wenkew186 — Wed, 13 Nov 2013 01:17:47 GMT

yes sir, it's same with first cell, but have any idea to solved? because the expression backgroup color will change with the data, so the tab will very strange to ever-change. thanks!

Re: table expression background calculate color tab & cell

bbi_mba_76 — Wed, 13 Nov 2013 07:52:37 GMT

Maybe adding a total row at the top of the pivot, the header should take the background ot the total.

Re: table expression background calculate color tab & cell

wenkew186 — Thu, 14 Nov 2013 01:18:30 GMT

sir,i have try to do it,but the total row color will change with data too, so the tab row backgroup color is not stable yet.

Re: table expression background calculate color tab & cell

Sokkorn — Thu, 14 Nov 2013 04:34:02 GMT

Hi,

Maybe you can try with this post.

Regards,

Sokkorn

Re: table expression background calculate color tab & cell

wenkew186 — Thu, 14 Nov 2013 06:39:08 GMT

yes sir, i'm try to follow these operate, but i found the rank of these setting always after calculate color of expression--backgroup color. so header backgroup color will change with cell row 1 together.

Re: table expression background calculate color tab & cell

Thu, 14 Nov 2013 06:48:41 GMT

Try with the Visualcues tab

Re: table expression background calculate color tab & cell

wenkew186 — Thu, 14 Nov 2013 07:26:34 GMT

how to do it, sir?

Re: table expression background calculate color tab & cell

Thu, 14 Nov 2013 07:43:12 GMT

Hi,

Go to view Menu of the document choose the design grid and then go to the Table right click on the tab and choose the custom format cell from the properties list give it the background color whichever you want.

Re: table expression background calculate color tab & cell

wenkew186 — Thu, 14 Nov 2013 08:27:33 GMT

sir, it's not enable. because i have do a calculate color in expression--backgroup. whatever i do these setting,but finaly, calculate color will replace all setting, and the tab will change with cell row 1. i just want tab color is don't change, and cell will change with data by backgroup color judge formula.