How to conditionally format empty/null cells in qivot table

[#1]

Hi there

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

if

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

didn't work

Your help would be appreciated.

[Anonymous]

try this it may help u

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

[#3]

hi srikanthsri1

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]

may this might help you

http://community.qlik.com/thread/38240?tstart=0