Discussion Board for collaboration related to QlikView App Development.
Hi Folks ... issue with section access
Below is the following script used by me and working fine to reduce the data and able to restrict the user at sheet level but the problem is .... when i'm opening the document with the user credentials then the document is reducing the data and sheets as well able to restrict and after closing the document. Before closing the document it prompts me to save the document and the same is reflecting when logged in as an admin .... now in order to see the complete document reload is done by logging as admin.
And one more problem here i'm facing is after logged as user when i reload the dashboard complete dashboard is loading inspite of user credentials.
Can Any one help me to overcome this scenario
Any settings need to be changed in case of this apart from Reduce tab>Initial data reduction checking
load * Inline [
ADMIN,ADMINISTRATOR,QLIKVIEW_4,* ,1 ,1 ,1
USER,SYEDRIZWAN,HORSE,PL0044 ,1 ,1 ,0
USER,NIRMALA,NIRMALA,*,0 ,0 ,1
load * inline [
ADMINISTRATOR,1 ,1 ,1
SYEDRIZWAN,1 ,1 ,0
NIRMALA,0 ,0 ,1
For the first question, I think you mean the "*" in section access does not mean all values, but all values listed in the column of the section access table. In your example, both users ADMINISTRATOR and NIRMALA will have POOLCODE PL0044. You will need to loop one of your admin users through that field an create one line per possible value that, including admins, you want to show.
For the second, do you mean you can still reload if logged in as a USER? If so, check the Security tab in the Settings > Document Settings > Security and uncheck "Allow User Reload"
Hi Miguel ... Thank you for the response
Question related to second one explained by you to uncheck user reload ....
The document is not scheduled in server this is used by the users with OEM license so if we restrict as you said the user will not be able to see the updated data. Now is there any other way to achieve this to show user only the data to be displayed according to the section access in spite of reload.
Whenever you do a change in the section access, you need to reload the application which has it. If you have one single, big application maybe it's worth separating the data model creation in one QVW, and the section access and binary load from the previous in another QVW.
You will need to reload both whenever there is new data, but if there is only new users, the latter will reload considerably faster.
You need to be aware that if the user has permission to perform reloads, and does so, then they will be able to see everything in the model.
Section access security is applied when the document is opened, not when it reloaded. When the document is reloaded, the user is able to see everything until they save and close the document. Security will then be applied when they attempt to re-open the document.
Thank you very much Jonathan for the useful information.