Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
amars
Specialist
Specialist

Showing all data using macro

Hi all,

I am using section access for a document but after open I wish to show all the data for that document. Is there some function to show all data for the document.

Regards

Amar

4 Replies
Anonymous
Not applicable

Section Access has two roles:
1. Allow or not to open application.
2. Restrict access to the data.
Part 2 is optional. Just uncheck "Initial data reduction..." on the Opening tab of the document properties. If a user can open the document - all data is available.

amars
Specialist
Specialist
Author

Hi Michael,

I want to identify the user that has logged in also. & After that want to show all the data. My data is getting reduced even the field used in section application has no relation with the rest of the data. & when I reload the file it show's all data. Despite getting into why this is happening I want to show all data using macro. Is there some way to do that (Without reload)

Regards

Amar

Not applicable

Amar,

maybe this example is helpful.

ACCESS, USERID, PASSWORD, GROUP
ADMIN, ADMIN, p, *
User, DEMO1, p, A
User, DEMO2, p, B
USER, DEMO3, p, C

Rainer

Anonymous
Not applicable

Correct Rainer,
It's not about macro - it is giving some users access to all data in Section Access. Certainly you must use initial data reduction in this case.