Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

How to conditionally format empty/null cells in qivot table

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.

Tags (2)
3 Replies
srikanthsri1
Valued Contributor

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

try this it may help u

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


Not applicable

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

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

srikanthsri1
Valued Contributor

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

Community Browser