Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

soniasweety
Valued Contributor III

Total column need in color

Hi All,

i want to show the Total column in  colour  

i tried custom format cell but am getting only dimensions with the required color 

how to show   total column as colour ?

Thanks

Sonytotal.PNG

Tags (3)
5 Replies
sibin_jacob
Contributor III

Re: Total column need in color

Go to expression tab -> Click on '+' symbol -> then Background Color

if (isnull(rowno()),RGB(0,255,0))



sibin_jacob
Contributor III

Re: Total column need in color

if it is a pivot table try this one

If(dimensionality()  = 0,RGB(0,255,0))

soniasweety
Valued Contributor III

Re: Total column need in color

Hi

if (isnull(rowno()),RGB(0,255,0))   this is working for that perticular expression only.

but i need entire total column as same color.

Note:  its stright table.

Highlighted
sibin_jacob
Contributor III

Re: Total column need in color

In that case, you need to give this formula in all the expressions and dimensions.

if (isnull(rowno()),RGB(0,255,0))


Go to dimension tab -. Click on '+' symbol -> then Background Color

soniasweety
Valued Contributor III

Re: Total column need in color

not worrking