Qlik Community

QlikView Security & Governance

Discussion Board for collaboration on QlikView Security and Governance.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

datagrrl
Contributor III

Section Access Reduction field includes NULL values

Hello-

I have an issue with an application. I am trying to implement Section Access for the first time.

I have users need access to all regions, but there is some dirty data with no (NULL) value for region.

If I use the "*" in the reduction field all records except for those with a NULL value in region are returned.\

I know it is more ideal to clean up the data, but the NULL regions actually mean something.

Any suggestions?

2 Replies
nagaiank
Valued Contributor III

Re: Section Access Reduction field includes NULL values

You may replace nulls with a meaningful non-null text

(e.g.  If(IsNull(Region),'Null-Region',Region) as Region)

and see if that helps your Section Access requirements.

datagrrl
Contributor III

Re: Section Access Reduction field includes NULL values

Okay, I was wondering if that was the best solution. Thanks for your help.