Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
kakani87
Specialist
Specialist

SECTION ACCESS ISSUE

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.

1 Solution

Accepted Solutions
kakani87
Specialist
Specialist
Author

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

View solution in original post

5 Replies
tamilarasu
Champion
Champion

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.

Capture.PNG

kakani87
Specialist
Specialist
Author

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.

kakani87
Specialist
Specialist
Author

For Information Purpose

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

kakani87
Specialist
Specialist
Author

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

tamilarasu
Champion
Champion

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!