Discussion board where members can get started with QlikView.
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 ?
Go to expression tab -> Click on '+' symbol -> then Background Color
if it is a pivot table try this one
If(dimensionality() = 0,RGB(0,255,0))
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.
In that case, you need to give this formula in all the expressions and dimensions.
Go to dimension tab -. Click on '+' symbol -> then Background Color