topic Re: Section Access Reduction field includes NULL values in QlikView https://community.qlik.com/t5/QlikView/Section-Access-Reduction-field-includes-NULL-values/m-p/766456#M1297963 <HTML><HEAD></HEAD><BODY><P>You may replace nulls with a meaningful non-null text</P><P></P><P>(e.g.&nbsp; If(IsNull(Region),'Null-Region',Region) as Region)</P><P></P><P>and see if that helps your Section Access requirements.</P></BODY></HTML> Fri, 09 Jan 2015 21:04:17 GMT nagaiank 2015-01-09T21:04:17Z Section Access Reduction field includes NULL values https://community.qlik.com/t5/QlikView/Section-Access-Reduction-field-includes-NULL-values/m-p/766455#M1297958 <HTML><HEAD></HEAD><BODY><P>Hello-</P><P></P><P>I have an issue with an application. I am trying to implement Section Access for the first time.</P><P></P><P>I have users need access to all regions, but there is some dirty data with no (NULL) value for region.</P><P></P><P>If I use the "*" in the reduction field all records except for those with a NULL value in region are returned.\</P><P></P><P>I know it is more ideal to clean up the data, but the NULL regions actually mean something.</P><P></P><P>Any suggestions?</P></BODY></HTML> Mon, 26 Jan 2026 18:19:17 GMT https://community.qlik.com/t5/QlikView/Section-Access-Reduction-field-includes-NULL-values/m-p/766455#M1297958 datagrrl 2026-01-26T18:19:17Z Re: Section Access Reduction field includes NULL values https://community.qlik.com/t5/QlikView/Section-Access-Reduction-field-includes-NULL-values/m-p/766456#M1297963 <HTML><HEAD></HEAD><BODY><P>You may replace nulls with a meaningful non-null text</P><P></P><P>(e.g.&nbsp; If(IsNull(Region),'Null-Region',Region) as Region)</P><P></P><P>and see if that helps your Section Access requirements.</P></BODY></HTML> Fri, 09 Jan 2015 21:04:17 GMT https://community.qlik.com/t5/QlikView/Section-Access-Reduction-field-includes-NULL-values/m-p/766456#M1297963 nagaiank 2015-01-09T21:04:17Z Re: Section Access Reduction field includes NULL values https://community.qlik.com/t5/QlikView/Section-Access-Reduction-field-includes-NULL-values/m-p/766457#M1297968 <HTML><HEAD></HEAD><BODY><P>Okay, I was wondering if that was the best solution. Thanks for your help.</P></BODY></HTML> Fri, 09 Jan 2015 21:09:54 GMT https://community.qlik.com/t5/QlikView/Section-Access-Reduction-field-includes-NULL-values/m-p/766457#M1297968 datagrrl 2015-01-09T21:09:54Z