I have created a qlikview that shows revenue by product division. There are three divisions: A, B and C.
I want to restrict access to the data, i.e., Tom, who is the GM of division A should only be able to see data pertaining to division A. Similarly, Sally, who is the GM of division B should only have access to division B data.
Is it possible to do this in the load script? Could you please share the syntax?
This helped in creating the userid and password prompt. But the data is not being restrictive as far as division is concerned. In other words, I created the following access table and script. But no matter who I log in as, I can see all divisions.