I have a Section Access in my Qlikview dashboard, with an ADMIN and some USERS. Now, the way I have designed Section Access is to have an additional field called as EMPLOYEEID, which maps to my data model and shows data only for that particular employee. Assume, I have total of 100 employees
I do not want all EMPLOYEEs to access the dashboard, thats why I have added only 5 USERS with different EMPLOYEEID in my Section Access file. Now, I want ADMIN to access data for all 100 Employees and not only the 5 Employees that are mentioned in the section access file. If I put * for Admin, I see data only for 5 Employees. What options do I have that will allow ADMIN to see data for all 100 employees, while not having all 100 rows in my Section Access table.
The above shows only data for EmployeedID 1,2,3,4,5 when I login as Administrator. This is not what I want.
I hope I have been able to explain the problem clearly.
Jonathan, thanks but I tried that and it doesnt work...the reason probably is this:
A wildcard, i. e. *, is interpreted as all (listed) values of this field, i.e. a value listed elsewhere in this table.
I copied this from the QV Help.
Any other thing that I can try?
Instead of using EMPLOYEEID in your section access, you just use a field like EMPLOYEEGRP. After this, in your section application, assign a EMPLOYEEGRP to your each EMPLOYEEID.
Apartfrom this, your approach put * for ADMIN is correct.
I don't understand that. Reload process itself is not related to client in any way.
In general, your problem is quite typical, and you correctly mentioned that "*, is interpreted as all (listed) values of this field". It is always resolved by blank value, like this:
LOAD * INLINE [
ACCESS, USERID, PASSWORD, FIELD
ADMIN, ADMIN, ADMIN,
USER, USER, USER, VALUE
Venu, in that case I will have to modify my database table to include a field like EMPLOYEEGRP, because only then will the section access be able to map it to the database...i am not looking to edit my database structure...