Allow nulls in set analysis

[surajap123]

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

[Vegar]

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