topic Re: How to use section access and star is in App Development

How to use section access and star is

agigliotti — Wed, 16 Sep 2015 07:42:34 GMT

Hello,

I need to apply no reduction data for a user.

I tried to do in the same way I did in QlikView using start is statement in section application.

Example:

section access;

USER REDUCTION

A 1

B 2

C 3

section application;

Start is *;

REDUCTION FIELD

1 T1

1 T2

2 T3

3 *

The user C should see all values of FIELD in data cloud.

But this is not working in QLIK SENSE.

How can I achieve it ?

Many thanks.

Andrea

Re: How to use section access and star is

Anonymous — Wed, 16 Sep 2015 11:51:26 GMT

Hello,

Section Access syntax has been modified in Qlik Sense. Please check help below.

https://help.qlik.com/sense/1.1/en-us/online/#../Subsystems/Hub/Content/Scripting/Security/SectionsInTheScript.htm

Serhan

Re: How to use section access and star is

agigliotti — Wed, 16 Sep 2015 12:53:20 GMT

I know but I'm asking how to do the same thing I did with QlikView.

Re: How to use section access and star is

Anonymous — Wed, 16 Sep 2015 13:28:04 GMT

Hello,

Are you trying exactly with the script you sent above?

If yes, there are a few issues with it.

1. You need ACCESS field specified.

2. In order to filter the users, you need USERID or GROUP field.

3. In order to star to work, you need all values already listed in REDUCTION field inside of Section Access block. STAR IS value list is composed of only the values listed in the section access area; it does not check the original list of values in data.

Code below works fine.

Sample USERID Value: 'DOMAIN\USER';

ACCESS field value: ADMIN or USER

//Code Starts here

section access;

LOAD

"ACCESS",

"USERID",

REDUCTION

FROM [lib://Desktop/test.xlsx]

(ooxml, embedded labels, table is Sheet1);

star is '*';

section application;

TEST:

LOAD

REDUCTION,

VALUE

FROM [lib://Desktop/test.xlsx]

(ooxml, embedded labels, table is Sheet2);

//Code ends here

Serhan

Re: How to use section access and star is

agigliotti — Thu, 17 Sep 2015 10:12:40 GMT

Hi,

No I used also ACCESS and USERID fields in section access.

So it's different from qlikview, where star in section application means all field values in data cloud and not in section access.

Are you sure is this the expected behaviour ?

Re: How to use section access and star is

Anonymous — Thu, 17 Sep 2015 10:28:44 GMT

Hello Andrea,

It is same behaviour in QlikView as well. If you don't include all values in section access, it does not authorize the star users properly as well.

Serhan

Re: How to use section access and star is

agigliotti — Thu, 17 Sep 2015 13:02:18 GMT

What you saying is the expected behaviour using star symbol in section access.