how to create user groups and grant permissions

[#1]

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

[#2]

Please explicate what you are trying to do?

[#3]

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

[#4]

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);

[#5]

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);

[#6]

how to write a hidden script?

[#7]

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

[narender123]

Hi ,

In script editor, File --> Create Hidden Script

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

Thanks,