topic Re: How to have an Admin/Super User in Section Access in QlikView

How to have an Admin/Super User in Section Access

Tue, 16 Jul 2013 11:49:37 GMT

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.

ACCESS	USERID	PASSWORD	EMPLOYEEID
ADMIN	ADMIN	ADMIN	*
USER	XXX	XXX	1
USER	XXX	XXX	2
USER	XXX	XXX	3
USER	XXX	XXX	4
USER	XXX	XXX	5

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.

Thanks,

Sagar

Re: How to have an Admin/Super User in Section Access

Anonymous — Tue, 16 Jul 2013 11:51:59 GMT

Add a line just after the Section Application; to declare the wildcard, as follows:

Star is *;

Jonathan

Re: How to have an Admin/Super User in Section Access

Tue, 16 Jul 2013 12:05:06 GMT

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?

Re: How to have an Admin/Super User in Section Access

Tue, 16 Jul 2013 12:24:34 GMT

Hi,

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.

Re: How to have an Admin/Super User in Section Access

Anonymous — Tue, 16 Jul 2013 12:25:53 GMT

Sagar,

Remove this *, leave it blank.

Regards,

Michael

Re: How to have an Admin/Super User in Section Access

Tue, 16 Jul 2013 12:29:45 GMT

Mike, blank is not recognized in the AJAX client...tried that option as well..

Re: How to have an Admin/Super User in Section Access

Anonymous — Tue, 16 Jul 2013 12:34:59 GMT

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

];

Re: How to have an Admin/Super User in Section Access

Tue, 16 Jul 2013 12:36:24 GMT

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...