topic Issue Formatting Totals in QlikView

Issue Formatting Totals

caio_caminoski — Tue, 11 Nov 2014 21:28:20 GMT

Hi guys,

I was working on a table with a few conditional formatting rules and I came across a problem.

As you can see in the image below, my total row is also getting afected by the format conditions I have used for my data.

I have tried a few rules to get able to avoid this behavior, but with no success. I also tried "Custom Format Cell" and, as I expected, didn't work.

Is there any workaround?

Thanks in advance!

afurtado — Tue, 11 Nov 2014 21:43:19 GMT

Hi.

maybe you can use Dimensionality().

if(Dimensionality()=0,rgb(x,x,x),.....)

Could you put a sample model?

Best,

Alessandro Furtado

caio_caminoski — Tue, 11 Nov 2014 22:30:57 GMT

Beautiful solution! I didn't know about this function!

Valeu Alessandro! Abraço

afurtado — Tue, 11 Nov 2014 22:37:52 GMT

grande abraço