Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Section access to provide access to all data to a few users

Hi,

I am trying to create a document with section access. I am using a reduction field to reduce the data on inital load based on user login. I need a way to display all the data to most of the users and only selected data to a few users. For example:

I am putting in section application section the following:

section access;

Directory $(vQVDPath);

LOAD NTNAME,

     ACCESS,

     GROUP

FROM

[Access Permissions.xlsx]

(ooxml, embedded labels, table is [User-Group]);

section application;

Directory $(vQVDPath);

LOAD GROUP,

          Currency

FROM

[Access Permissions.xlsx]

(ooxml, embedded labels, table is [Group-Permissions]);

In the Group-Permissions sheet, I have the following:

GROUP          CURRENCY

GRP1               USD

GRP2               GBP

GRP3               JPY

GRP4                ????

My question is on group 4. My data has more than 20 currencies. I want GRP4 to be able to view all these 20 currencies and GRP1, GRP2, GRP3 only 1 currency each as per the table above. I have tried using * but that essentially means that GRP4 will be able to access only USD, GBP and JPY. I tried leaving it blank but in that case GRP4 doesn't get access to any currency.

Please let me know if there is a way to solve this.

Thanks.

1 Reply
amars
Valued Contributor

Re: Section access to provide access to all data to a few users

Hi,

You can use all the 20 currencies in ur Section Application Against GRP4,

See Attached Example

LOAD * INLINE [
    Value, Currency
    1000, USD
    2000, GBP
    2500, JPY
    3000, INR
    2200, SGD
    1400, DNR
];

Section Access;
LOAD * INLINE [
    ACCESS, USERID, PASSWORD, GROUP
    User, ABC, *, GRP1
    User, PQR, *, GRP2
    User, XYZ, *, GRP3
];
Section Application;
LOAD * INLINE [
GROUP, Currency
GRP1, USD
GRP2, GBP
GRP3, USD
GRP3, GBP
GRP3, JPY
GRP3, INR
GRP3, SGD
GRP3, DNR
];

Note:- While using Section Access rather than using "Initial data reduction based on section Access", use "Initial data selection based on Section Access" until ur testing is complete.

Thanks

Community Browser