Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

wenkew186
New Contributor III

table expression background calculate color tab & cell

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.

Tags (2)
10 Replies
bbi_mba_76
Valued Contributor

Re: table expression background calculate color tab & cell

Hi,

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

wenkew186
New Contributor III

Re: table expression background calculate color tab & cell

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!

bbi_mba_76
Valued Contributor

Re: table expression background calculate color tab & cell

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

wenkew186
New Contributor III

Re: table expression background calculate color tab & cell

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.

Sokkorn
Honored Contributor

Re: table expression background calculate color tab & cell

Hi,

Maybe you can try with this post.

Regards,

Sokkorn

wenkew186
New Contributor III

Re: table expression background calculate color tab & cell

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.

Not applicable

Re: table expression background calculate color tab & cell

Try with the Visualcues tab

wenkew186
New Contributor III

Re: table expression background calculate color tab & cell

how to do it, sir?

Not applicable

Re: table expression background calculate color  tab & cell

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.

Community Browser