Nothing or Null on reduction column will look like complete set of data in QlikView Development Client but when document is hosted in Accesspoint users having that access will not be able to get through.
Ok let me explain with an example on what I mean here.
In above section access script I struck two rows (of NTNAME column) for security reasons, so i’ll put some dummy values for explanation purpose here. One has blank value and other one has * value on reduction column.
ACCESS, NTNAME, COUNTRY
ADMIN, ABC,
ADMIN, XYZ, *
Other important points to note on the above screen shot are:
- Value ‘India’ on reduction column is not assigned to anybody
- NTNAMEs that I have used other struck are dummy names
QlikView Desktop Behavior:
User having ” * ” on reduction column – Row with India is missing.
User having ” ” (Null) value on reduction column – Can see India record.
User having ” * ” on reduction column – Will have similar access as Desktop user.
User having ” ” (Null) value on reduction column – Will not be able to open up the dashboard, prompted with below pop-up.
Conclusion: So Null or Nothing doesn’t mean everything at least in QlikView Accesspoint.