topic Re: how to create user groups and grant permissions in QlikView

how to create user groups and grant permissions

Fri, 13 Sep 2013 07:08:25 GMT

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

Re: how to create user groups and grant permissions

Fri, 13 Sep 2013 07:17:23 GMT

Please explicate what you are trying to do?

Re: how to create user groups and grant permissions

Fri, 13 Sep 2013 07:25:37 GMT

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

Re: how to create user groups and grant permissions

Fri, 13 Sep 2013 07:27:07 GMT

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

Re: how to create user groups and grant permissions

Fri, 13 Sep 2013 07:39:20 GMT

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

Re: how to create user groups and grant permissions

Fri, 13 Sep 2013 07:48:09 GMT

how to write a hidden script?

Re: how to create user groups and grant permissions

Fri, 13 Sep 2013 08:03:42 GMT

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

Re: how to create user groups and grant permissions

narender123 — Fri, 13 Sep 2013 08:09:15 GMT

Hi ,

In script editor, File --> Create Hidden Script

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

Thanks,