Access Null data Values in qlikview

[djaykumar]

Hi All,

I am struggling with null data set to display USER by using Session Access in qlikview

I am using NTName for USER to display Qlikview reports. I am succeeded to display all the required fields to the USER.

But lastly I am not able to give access for the USER as well as Admin for NULL Values. For example, I have

Dept               Value

HR                   200

Finance        400

Accounts      600

-                       300

in the above data I am able to give access for the USER and ADMIN having Depts HR,Finance and Accounts.

But NULL Dept is not displaying .

I have used *,-, (space). But not getting NULL Values.

Please help me in this

Thanks in Advance

Jay

[jonathandienst]

In Qlik's associative model, nulls cannot associate, so you won't be able to associate the section access table to a null valued department. I suggest that you modify your load to ensure that the field associated with the section access table contains no nulls, or use the variable NullAsValue to set the nulls to a value (eg, 'NULL', or and empty string).

[Brett_Bleess]

So the key thing here is if you have a reduction field in your Section Access load?  If so, if you want everyone to see everything, the reduction field would need to be 'blank' for the user you want to be able to see all values, as I believe that should also pick up the 'null' one at that point, but I am not certain of it.  

Here is the Help link to Section Access as well, this may help too:

http://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/Security.htm

What we generally recommend is the service account has reduction field values of 'blank' that way it will always load and see all data, but if Strict Exclusion is enabled in the Opening tab of the Document Properties, that will result in the app not opening via QlikView Server for the service account, just FYI, as everyone is a USER when they open via the server, you are only an ADMIN when using Desktop Client, just FYI, a fact a lot of people miss.  Hope this helps.

Regards,
Brett