Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
how to create user groups dependinding on the roles in qlikview?
Please explicate what you are trying to do?
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);
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);
how to write a hidden script?
Open the skript editor --> file and than create hidden skript