Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to create user groups and grant permissions


how to create user groups dependinding on the roles in qlikview?

7 Replies
Not applicable
Author

Please explicate what you are trying to do?


Not applicable
Author

How do I create users and assign them to groups in Qlikview,how to grant access on different aggregation based on roles in qlikview

Not applicable
Author

You must create a data like the excel.

And than you have to read the excel file in your qvw.

I would recommend to create a hidden-skript and add the following...

Section Access;

Zugriff:
LOAD
ACCESS,
USERID,
PASSWORD,
NTNAME,
GROUP,
FROM
[..\2_Arbeitsdaten\Berechtigungen_Qlikview_2012.xlsx]
(
ooxml, embedded labels, table is User);


Section Application;

Berechtigungen:
LOAD
GROUP,
[
Arbeitsblatt 1],

[Arbeitsblatt 2],

  [Arbeitsblatt 3],      //add the name of the other work sheets

FROM
[..\2_Arbeitsdaten\Berechtigungen_Qlikview_2012.xlsx]
(
ooxml, embedded labels, table is Berechtigungs_Matrix_QV);

Not applicable
Author

If you want to restrict the data of sales persons. That the only can see their own data use this

example excel file and add the following to the hidden-skript

Section Access;

Zugriff:
LOAD
ACCESS,
USERID,
PASSWORD,
NTNAME,
GROUP,
SalesPerson
FROM
[..\2_Arbeitsdaten\Berechtigungen_Qlikview_2012.xlsx]
(
ooxml, embedded labels, table is User);


Section Application;

Zugriff01:
LOAD SalesPerson,
PersonalNr
FROM
[..\2_Arbeitsdaten\Berechtigungen_Qlikview_2012.xlsx]
(
ooxml, embedded labels, table is Verträter);



Berechtigungen:
LOAD
GROUP,
[
Arbeitsblatt 1],

     [Arbeitsblatt 2],

     [Arbeitsblatt 3],


FROM
[..\2_Arbeitsdaten\Berechtigungen_Qlikview_2012.xlsx]
(
ooxml, embedded labels, table is Berechtigungs_Matrix_QV);

Not applicable
Author

how to write a hidden script?

Not applicable
Author

Open the skript editor --> file  and than create hidden skript

narender123
Specialist
Specialist

Hi ,

In script editor, File --> Create Hidden Script

QlikView ask about a password and show a new sheet......save...close.....and open again....

Thanks,