Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Expert,
Can you please help me how to perform authorization in qlikview.
Below is my requirement.
Authorization:
Case: There is one All India Head Mr. Ram who can view the Records
at All India Level (North, South, East and West)
4 Regional Managers reporting to him can see data for their respective
Region.
Can you please help us out how toachieve end result in this.
Thanks,
Hi Deepak,
First create a section accession where to set the rights:
Section Access;
LOAD
* INLINE
[
ACCESS, USERID, PASSWORD, REGION
ADMIN, ADMIN, ADMIN123, *
USER, HEAD,HEAD123,*
USER, A, USER123, EAST
USER, B, USER456, WEST
USER, C, USER789, NORTH
USER, D, USER345, SOUTH
];
If a user may see severel regions, just repeat the line but with another REGION.
Take care also that the fields MUST be UPPERCASE
Take care also that the * does NOT mean anything, but everything listed below (here it is OK because you have the 4 regions)
SECTION Application;
Here you will your data. I assume you have a REGION field to do the link with the rights.
If you need to intersect (REGION / PRODUCT) you will need to create a composite key.
Fabrice
Hello Expert,
When I have created script as per mentioned above right now it is showing data only for west region.
Though I have removed the hidden script the problem still occurs.I am only able to see data for west region.
Can you please suggest on this.
Thanks,
Hi Deepak,
You can use either Section Access and Section Application feature in QlikView or impliment this through QlikView Publisher.
Hope it will help.
Hello FABRICE,
Although after making above changes in a script it is still showing me all regions for all users.
It is not able to give access as per mentioned in a script.
Can you please suggest on this.
Thanks,
In document properties, opening tab, have you marked the initial data reduction based on section access ?
Hi Michele,
I haven't selected that option
Thanks,
Please find below code for section access.
It is working fine as it is.
Section Access;
LOAD * INLINE
[
ACCESS, USERID, PASSWORD
ADMIN, ADMIN, ADMIN123
USER, HEAD,HEAD123
USER, A, USER123
];
Section Application;
LOAD * INLINE
[
USERID, Region
ADMIN,North
ADMIN,South
ADMIN,East
ADMIN,West
HEAD,North
A,South
];
But as per requirement I need to put all my user id pw and corresponding regions(Code for section access and section application) in another excel file.But after putting access ,userid and password in excel and after calling the same it is not working can you please suggest on this.
Thanks in advance.
Regards,
Deepak
Please find below code for section access.
It is working fine as it is.
Section Access;
LOAD * INLINE
[
ACCESS, USERID, PASSWORD
ADMIN, ADMIN, ADMIN123
USER, HEAD,HEAD123
USER, A, USER123
];
Section Application;
LOAD * INLINE
[
USERID, Region
ADMIN,North
ADMIN,South
ADMIN,East
ADMIN,West
HEAD,North
A,South
];
But as per requirement I need to put all my user id pw and corresponding regions(Code for section access and section application) in another excel file.But after putting access ,userid and password in excel and after calling the same it is not working can you please suggest on this.
Thanks in advance.
Regards,
Deepak