Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I am in dire need of help with section access. I have seen examples on how to go about creating the section access, as seen below.
Section Access;
LOAD * INLINE [
ACCESS, USERID, PASSWORD
ADMIN, 1, 1
USER, 2, 2
USER, 3, 3
];
How should I go about scripting if I would like to retrieve the User_type - which is values 2, for users and 3 for admins, User_name - to login and User_pwd - to login. All of which is retrieved from MySQL.
Btw, I am a total newbie to QlikView. Just started this as I thought it would be good for my business. Please do help me.
Thanks
Wayne.
You have two function to retrieve user:
QV User: QVuser( )
Windows User: OSuser()
For QlikView user is QVuser()
Sorry, I don't quite understand. Can I link the User_name from the database to be a QV User?
sorry, I had not understood
Hi,
You mean what you want to know QV can get the user id and password from MYSQL ?
WanKi,
Can you be more specific and give some sample data.
Hi,
I think you have to retrieve information from database and Qlikview inline tables
and create and store a complete security table in your qvd after applying all transformations that you requires.
Then use this qvd and apply section access make sure to load this qvd unoptimized.
Regards
ASHFAQ