topic Re: SECTION ACCESS ISSUE in QlikView

SECTION ACCESS ISSUE

kakani87 — Thu, 15 Feb 2018 05:47:17 GMT

Hi Everyone,

I'm working on section access and the issue here is when i logged in as a user restricting properly but when i click the clear button it is showing the other user data as well.

Particularly when i click clear it is navigating to the restricted tab/sheet for the user

here I'm sharing the sample to analyse with login details

USERID PWD

SAI 123

AJITH 123

ADMIN 123

Any help is appreciable.

Regards,

Kishore.

Re: SECTION ACCESS ISSUE

tamilarasu — Thu, 15 Feb 2018 06:13:52 GMT

Hi,

Please find the attached file. I have done multiple changes.

1) Compare the script of your version of file and my version.

2) Check the show sheet expression.

3) You have to enable the below option in the document properties.

Re: SECTION ACCESS ISSUE

kakani87 — Thu, 15 Feb 2018 06:32:01 GMT

Thank you Nagaraj for the quick response.

Here when i reload the document as user with Initial data reduction based on section access checked instead initial selection based on section Access the other data as well reflecting here and tab access is not restricted here in your version.

Re: SECTION ACCESS ISSUE

kakani87 — Thu, 15 Feb 2018 07:51:32 GMT

For Information Purpose

This document is not deployed in server as the document is a OEM license leased not from the server leased license

Re: SECTION ACCESS ISSUE

kakani87 — Mon, 19 Feb 2018 11:31:58 GMT

Hi Nagaraj Thank you ....

using a macro for Save and Exit i'm able to achieve this

Added a macro like below to save and quit by checking as you suggested.

Initial Data Reduction Based On Section Access instead of Initial Selection Based on Section Access

so when ever user perform reload automatically the dashboard closed and user need to access again to see the data then this is getting restricted accordingly.

triggers > On post reload > assigned 'SaveAndQuit'

SUB SaveAndQuit

ActiveDocument.Save

ActiveDocument.GetApplication.Quit

END SUB

Re: SECTION ACCESS ISSUE

tamilarasu — Tue, 20 Feb 2018 01:56:58 GMT

Hi Saikishore,

I'm glad you solved your problem and sorry I couldn't get time to check community so I was not able to help you. I like your idea. Have a fantastic day!