topic Re: Null Values in QlikView

Null Values

kalyandg — Mon, 31 Dec 2012 04:27:39 GMT

I have a issue for null values, my client needs to display null values as red color in pivot table through the visual cues,

I think we can do it by unchecking a supress zero values, in the presentation tab, but i dont want to do like this,

is there any expr to be used in visual cues, as if null value show in red color?

please help me to solve this prob.

Thanks,

Kalyan

Re: Null Values

khadeer — Mon, 31 Dec 2012 04:58:41 GMT

if(Expression= null(),RGB(255,0,0)

regards,

Khadeer

Re: Null Values

kalyandg — Mon, 31 Dec 2012 05:12:21 GMT

hi Khadeer,

Thanks, it works

Re: Null Values

kalyandg — Mon, 31 Dec 2012 08:49:20 GMT

its not working

Re: Null Values

hic — Mon, 31 Dec 2012 09:53:31 GMT

No, comparing with NULL never works. It will always show false.

Use IsNull(Expression) instead. Or Len(Trim(Expression))=0.

HIC

Re: Null Values

kalyandg — Fri, 04 Jan 2013 07:26:59 GMT

hi Henric,

Thank you for help.

I need to set red color for null values displaying in pivot table, your expression is working, but in the visual cues tab we set some range for green and red. i had set green for all the values displaying and till i need to set red for null values.

how can i do that.......... please help me to solve.