While this is no longer a problem in QlikSense, I wanted to ask and confirm that it is still a problem in QlikView...
An application exists already which provides data organized by a facility id which, previously was accessible to all. Now, the use case is that some new users will be added but they are only allowed to access 2 or 3 of the 40-50 facility ids.
What I WISH I could do is add section access with ADMIN role for the AD group that currently has access and then specify the new users to be restricted. But you can't do it like this
Section Access;
LOAD * INLINE [
ACCESS, NTNAME, RESTRICTFACILITY
ADMIN, ADGROUPNAME, *
USER, NEWPERSON, FACILITY001
];
Section Application;
because the * will only provide access for FACILITY001. I think I have to loop over the existing data in the load script and generate "dummy rows" like this:
LOAD * INLINE [
ACCESS, NTNAME, RESTRICTFACILITY
ADMIN, ADGROUPNAME, FACILITY001
ADMIN, ADGROUPNAME, FACILITY002
ADMIN, ADGROUPNAME, FACILITY003
USER, NEWPERSON, FACILITY001
];
Is this still how it works?
Even better would be if something like this worked:
LOAD * INLINE [
ACCESS, NTNAME, RESTRICTFACILITY
ADMIN, *, *
USER, NEWPERSON, FACILITY001
];
and yes, I have read the documentation and worked on this for years so a simple "yes, you have do the dummy rows" is fine if I have not missed some great solution.
