Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On-Demand Webinar: Learn proven best practices for a smooth transition to Qlik Sense® SaaS. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
kalyandg
Partner - Creator III
Partner - Creator III

Null Values

Hi

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

1 Solution

Accepted Solutions
hic
Employee
Employee

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

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

HIC

View solution in original post

5 Replies
khadeer
Specialist
Specialist

Hi

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

regards,

Khadeer

kalyandg
Partner - Creator III
Partner - Creator III
Author

hi Khadeer,

Thanks, it works

kalyandg
Partner - Creator III
Partner - Creator III
Author

hi

its not working

hic
Employee
Employee

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

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

HIC

kalyandg
Partner - Creator III
Partner - Creator III
Author

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.