topic Re: How to conditionally format empty/null cells in qivot table in QlikView

How to conditionally format empty/null cells in qivot table

Tue, 19 Jun 2012 16:49:30 GMT

Hi there

I'm trying to do a conditional format where I take the null or empty values and highlight with a particular color.

(IsNull(sum(Units/[Units/Case]), rgb(119,136,153)))

didn't work

Your help would be appreciated.

Anonymous — Tue, 19 Jun 2012 17:05:43 GMT

try this it may help u

if(sum(exp)=null(),rgb(119,136,153)

Tue, 19 Jun 2012 17:15:16 GMT

i tried as you suggested, still didnt seem to work, i tried it in the attached document.

my syntax was the following:

if(sum([Units]/[Units/Case])=null(),rgb(119,136,153))

Thanks

Anonymous — Wed, 20 Jun 2012 16:53:45 GMT

may this might help you