Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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.

3 Replies
Anonymous
Not applicable
Author

try this it may help u

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


Not applicable
Author

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
Not applicable
Author