topic Re: question on section access in QlikView

question on section access

Anonymous — Tue, 15 Dec 2015 12:50:47 GMT

I am trying to give section access to users. and Use the NIH_IC as a variable in the report. vIC=only(NIH_IC). . do I have to store this field somewhere.

- I reload the file after saving the excel. attached is the excel. Please suggest.

Here is the script.

SECTION ACCESS;

trace <<< SECTION ACCESS >>> ;

SAccess:
LOAD ACCESS,
NTNAME,
NIH_IC
FROM
[\\nihdqv1\03_SourceDocuments\03.ICS\CIT\Admin Testing\EO Dash Development\Final Version\Padma\V1\SectionAccess.xlsx]
(ooxml, embedded labels, table is Sheet1);

trace <<< SECTION APPLICATION >>> ;

SECTION APPLICATION;

Re: question on section access

Tue, 15 Dec 2015 16:35:32 GMT

section access will identify what type of user you are (admin or user) and tries to reduce the datamodel (or island tables) based on what fields that you have given. in your example you should have NIH_IC field some where in your data model (or island table)

Re: question on section access

marcus_sommer — Tue, 15 Dec 2015 19:34:26 GMT

Here a lot of useful links to this topic: Section Access‌

- Marcus