topic Re: Total column need in color in QlikView

Total column need in color

soniasweety — Wed, 25 Nov 2020 16:16:04 GMT

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

Sony

sibin_jacob — Wed, 08 Aug 2018 07:58:03 GMT

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

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

sibin_jacob — Wed, 08 Aug 2018 08:00:42 GMT

if it is a pivot table try this one

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

soniasweety — Wed, 08 Aug 2018 08:05:19 GMT

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 — Wed, 08 Aug 2018 08:10:03 GMT

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 — Wed, 08 Aug 2018 08:21:17 GMT

not worrking