https://community.qlik.com/t5/QlikView/Allow-nulls-in-set-analysis/m-p/1926179#M1218775 <P>Hi There,</P> <P>I have a field in the table that has no values for the values in other columns.</P> <P>In the set analysis, i want to allow these null values.</P> <P>eg- sum({&lt;field = {'xx','yy'}&gt;}sales)</P> <P>In the above expression how can i ALSO allow null values?</P> <P>&nbsp;</P> <P>Thanks</P> Wed, 04 May 2022 10:43:11 GMT surajap123 2022-05-04T10:43:11Z https://community.qlik.com/t5/QlikView/Allow-nulls-in-set-analysis/m-p/1926179#M1218775 <P>Hi There,</P> <P>I have a field in the table that has no values for the values in other columns.</P> <P>In the set analysis, i want to allow these null values.</P> <P>eg- sum({&lt;field = {'xx','yy'}&gt;}sales)</P> <P>In the above expression how can i ALSO allow null values?</P> <P>&nbsp;</P> <P>Thanks</P> Wed, 04 May 2022 10:43:11 GMT https://community.qlik.com/t5/QlikView/Allow-nulls-in-set-analysis/m-p/1926179#M1218775 surajap123 2022-05-04T10:43:11Z https://community.qlik.com/t5/QlikView/Allow-nulls-in-set-analysis/m-p/1926357#M1218793 <P>I would recommend&nbsp; you to take a look at Henric Cronströms post about NULL handling in QlikView.</P> <P><A href="https://community.qlik.com/t5/QlikView-Documents/NULL-handling-in-QlikView/ta-p/1484472/show-comments/true" target="_blank">https://community.qlik.com/t5/QlikView-Documents/NULL-handling-in-QlikView/ta-p/1484472/show-comments/true</A></P> <P>Take a look at the pdf in that post, it contains a section about set analysis.</P> <P>-Vegar</P> Wed, 04 May 2022 14:38:04 GMT https://community.qlik.com/t5/QlikView/Allow-nulls-in-set-analysis/m-p/1926357#M1218793 Vegar 2022-05-04T14:38:04Z