topic Re: Section Access Help - Data Reduction in QlikView

Section Access Help - Data Reduction

tahirkhalil — Wed, 04 Nov 2015 05:55:37 GMT

I have a case - in section access I have following entries:

USER NTNAME ZoneLevel

ADMIN, *, *

USER, TEST1, SOUTH

USER, TEST2, NORTH

USER, TEST3, CENTRAL

How is it possible to give access to a new user TEST4 for both SOUTH & NORTH?

Regards,

Tahir

Re: Section Access Help - Data Reduction

oknotsen — Wed, 04 Nov 2015 09:40:28 GMT

Remove ZoneLevel from the Section Access table and instead add a Profile column.

Make a new (inline) table called "AccessProfile" in which you combine Profile with ZoneLevel.

You can now add multiple lines in this "AccessProfile" table, one for every ZoneLevel you want to give someone access to.

Re: Section Access Help - Data Reduction

sasikanth — Wed, 04 Nov 2015 10:13:16 GMT

hi,

Try Some thing like this,

Section Access;

Load * INLINE [

USER ,NTNAME

ADMIN,TEST

USER, TEST1

USER, TEST2

USER, TEST3

USER,TEST4

USER,TEST5

];

load Another table

LOAD * INLINE [

NTNAME,ZONELEVEL

TEST1,SOUTH

TEST2,NORTH

TEST3,CENTRAL

TEST4,SOUTH

TEST4,NORTH

];

Section Application;

Re: Section Access Help - Data Reduction

hic — Wed, 04 Nov 2015 10:14:28 GMT

... or just add TEST4 on two lines:

ADMIN, *, *

USER, TEST1, SOUTH

USER, TEST2, NORTH

USER, TEST3, CENTRAL

USER, TEST4, SOUTH

USER, TEST4, NORTH

HIC

Re: Section Access Help - Data Reduction

tahirkhalil — Wed, 04 Nov 2015 11:20:48 GMT

Hi Onno

Please see the attached QV doc.

The section access is not working - no idea why?

Hidden script password is 123

This is hidden script:

STAR IS *;

Section Access;

LOAD * INLINE [

ACCESS, USERID, AccessProfile

ADMIN, USER1, PROFILEC

USER, USER2, PROFILEN

USER, USER3, PROFILES

];

Section Application;

[AccessProfile]:

LOAD * INLINE [

Zone, AccessProfile

CENTRAL, PROFILEC

NORTH, PROFILEN

SOUTH, PROFILES

];

STAR IS ;

Re: Section Access Help - Data Reduction

oknotsen — Wed, 04 Nov 2015 11:59:42 GMT

Hi,

IIRC the name of all the columns in the section access table need to be in ALL CAPS.

So AccessProfile should be ACCESSPROFILE.

Re: Section Access Help - Data Reduction

tahirkhalil — Wed, 04 Nov 2015 12:24:09 GMT

Thank you - I missed that

Thanks for your help.