topic Showing all data using macro in QlikView

Showing all data using macro

amars — Wed, 05 Aug 2009 21:18:39 GMT

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

Showing all data using macro

Anonymous — Wed, 05 Aug 2009 23:55:56 GMT

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.

Showing all data using macro

amars — Thu, 06 Aug 2009 16:05:20 GMT

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

Showing all data using macro

Thu, 06 Aug 2009 18:20:15 GMT

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

Showing all data using macro

Anonymous — Fri, 07 Aug 2009 00:29:47 GMT

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.