Hello all, I have a seccion access for the security like this: Section Access; [USERID],[PASSWORD],upper(GRUPPE),[ACCESS]; Section aplication;LOAD upper(GRUPPE),SystemUserId; I have 70 users on the application. I create a Table in Excel with USERID, PASSWORD, GRUPPE. Now I will control the User-Access for the Application with a SingleSignOn or the possibility, that every User have to change the Password after the first login. How can I handle this in QlikView.
Please see enclosed. I have put plenty of comments in the script to make itself explainable. Please open the document with user "admin" and password "1234". Please pay attention to the Settings -> Document Properties -> Data reduction checkboxes in "Opening" tab
Now I have another question. My application has 4 worksheets. The user should see all data on the first and on the fourth sheet. On the second and third sheet, the user should see only this data on which it rights has. Do you have an idea, how could I handle this?
Yes, you may load another field in the "Users" table in the begining which will identify the column ID and value this user should be filtered to. Then, load thie field "WhoAmI" table as well.
In my example, I have added a COUNTRY field as filter criteria. Please see enclosed. I would surely need to have COUNTRY filed in my application data tables (like Sales or Invoice tables, Or customer master). Then all the application data will be reduced to the value of this field, after user sign-on.
Hope this help. And if it does, please verify the answer.
