Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
soniasweety
Master
Master

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

5 Replies
sibin_jacob
Creator III
Creator III

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

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



sibin_jacob
Creator III
Creator III

if it is a pivot table try this one

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

soniasweety
Master
Master
Author

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.

sibin_jacob
Creator III
Creator III

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
Master
Master
Author

not worrking