Discussion Board for collaboration on QlikView Security and Governance.
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.
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.
Okay, I was wondering if that was the best solution. Thanks for your help.