topic Re: Assign different rights for „admin“ and „user“ users in QlikView

Assign different rights for „admin“ and „user“ users

Mon, 26 Jan 2026 18:19:17 GMT

Hello everyone,

I was keep searching for an answer in community, but couldn't find it clearly expressed.

I am trying to create different logins on my QlikView application, but I find difficult to do it. Can anyone explain how to do it step by step, cause I am quite new in developing QlikView applications. Thank you in advance.

Re: Assign different rights for „admin“ and „user“ users

stigchel — Thu, 26 Mar 2015 09:50:40 GMT

You need to look for Section Access, the ADMIN and USER keywords for the ACCESS field from section Access are system values to restrict access to the document properties in an offline distribution solution and not for assigning any other access rights.

Like said, for assigning different rights look into section Access. You can look in the help (Security) or search the forum. e.g. Here's an introduction to section access:

Introduction to Section Access

Re: Assign different rights for „admin“ and „user“ users

Thu, 26 Mar 2015 10:37:22 GMT

Thank you for your answer, but I couldn't understand one more thing:

i.e. I have two different tabs on my document: Sheet1 and Sheet2

and I would like to have two different users: user1 and user2

What I would like to do is that user1 could see only Sheet1 and user2 – Sheet2.

What is more, I preffer that user1 can edit script and user2 don't have that option.

How the script should look like?

Re: Assign different rights for „admin“ and „user“ users

stigchel — Thu, 26 Mar 2015 11:31:46 GMT

I've made an example for you, see attached, the passwords for opening this document can be found in the pasted script below. The user Administrator can see all and make changes to the document, User1 and User2 can see sheet1 and sheet2 respectively and not make changes

SECTION Access;

LOAD * Inline [ACCESS,USERID,PASSWORD, ACCESSGROUP

ADMIN,Administrator,Admin1,ALL

USER,User1,Access1,SHEET1

USER,User2,Access2,SHEET2

];

Section Application;

star is *;

LOAD * Inline [ACCESSGROUP

'ALL'

'SHEET1'

'SHEET2'

];

Re: Assign different rights for „admin“ and „user“ users

Thu, 26 Mar 2015 11:33:49 GMT

Thanks a lot.

And what about editing or reloading script?

Re: Assign different rights for „admin“ and „user“ users

stigchel — Thu, 26 Mar 2015 12:49:50 GMT

If you want to prevent editing and reloading the script the you can make a source qvw which you keep for making changes and a copy of that document for distributing. In the source document\document properties you check the prohibit binary load option. In the copy of you replace all loadscript with a binary load statement of the source document. This copy of the original now has no load script to edit and will not reload the source as it is prohibited.

Re: Assign different rights for „admin“ and „user“ users

Thu, 26 Mar 2015 13:15:53 GMT

By the way, I tried to use your expression (ACCESSGROUP='SHEET2' or ACCESSGROUP='ALL') in all of my sheets and I've got that all the users see the same. Is it bug or?...

Re: Assign different rights for „admin“ and „user“ users

stigchel — Thu, 26 Mar 2015 13:19:24 GMT

The section access must have been loaded with in the document properties\opening the option initial data reduction based on section access checked and finally saved. After that you have to close qlikview and reopen it.