Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
surajap123
Creator II
Creator II

Allow nulls in set analysis

Hi There,

I have a field in the table that has no values for the values in other columns.

In the set analysis, i want to allow these null values.

eg- sum({<field = {'xx','yy'}>}sales)

In the above expression how can i ALSO allow null values?

 

Thanks

Labels (1)
1 Reply
Vegar
MVP
MVP

I would recommend  you to take a look at Henric Cronströms post about NULL handling in QlikView.

https://community.qlik.com/t5/QlikView-Documents/NULL-handling-in-QlikView/ta-p/1484472/show-comment...

Take a look at the pdf in that post, it contains a section about set analysis.

-Vegar