Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist III
Specialist 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
Highlighted
Creator III
Creator III

Re: Total column need in color

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

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



Highlighted
Creator III
Creator III

Re: Total column need in color

if it is a pivot table try this one

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

Highlighted
Specialist III
Specialist 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
Creator III
Creator 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

Highlighted
Specialist III
Specialist III

Re: Total column need in color

not worrking