Allow nulls in set analysis

surajap123 · ‎2022-05-04

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 · ‎2022-05-04

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

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

-Vegar