Null values and Session Access

[#1]

Hello everyone,

I want to grant right access for some fields values with the session access.

For the admin user, i want to give all the rights.

The issue is that if a field value is not linked with a value of a field that I had given the right, I lose it even for the admin user.

here is my script:

Section Access;

LOAD * INLINE [

    ACCESS, NTNAME, GROUP

     ADMIN, ADMINISTRATOR, ALL

    ADMIN, FJKIOP, ALL

    USER, IOPLKJJ, ALL

    USER, IUYTGFD, 1

    USER, IOPPLKJ, 2

    USER, UIOOPL, 3

];

Section Application;

star is *;

LOAD * INLINE [

    GROUP, VENDOR.PARENT_REF

    ALL, *

    2, 1012

    1, 1035

    3, CENTRAL

];

I get this result without the session access:

and with the session access I lose the highlight rows like bellow  for the admin session:

Can someone help me please?

Thank you in advance.

[Colin-Albert]

Star (*) in the section access table does not mean "All values in the field", it means "All values in the section access table".

To allow access to all values, then you must populate all of the possible values into the section access table.

This can be against a DUMMY record in the ACCESS column.

Have a look at these examples for more details

https://community.qlik.com/docs/DOC-5917

[#3]

Hello thanks a lot for your answer. But the field on which i made the section access is not systematically linked with the Sales. So when the admin user is connected to the document, he wont see these 'no linked' sales.

Regards

[#4]

Hello ,

to be clearer please find  in attachement a test file where the issue is reproduced.

Here is my session acces script:

Section Access;

LOAD * INLINE [

    ACCESS, USERID, PASSWORD,GROUP

    ADMIN, ADMIN, ADMIN,1

    USER, USER1, USER1,2

    USER, USER2, USER2,3

];

section Application;

STAR IS '*';

LOAD * INLINE [

    GROUP, ProductID

    1, *

    2, 750

    3, 810

];

When you are logged as ADMIN  you have access at all of the datas linked to the ProductID. But If this field is null, like for the orderID n°6, I cannot see the amount.

Thank you for your help !

[jfkinspari]

Well, what

LOAD * INLINE [

    GROUP, ProductID

    1, *

    2, 750

    3, 810

];

say is that GROUP 1 gets access to all values in ProductID. If some transactions do not have a value, they will be excluded. A solution could be to find another (read: better) field to use for Section Access or populate the ProductID field, so it always have a value, e.g. -1

[jafari_ervin]

please see the attachment.

I created sample data in excel file and insert order-Id 6 with null product-Id.

[marcus_sommer]

You need to get a real value instead of NULL which then could be connected. Maybe in this way below which considered not only NULL else empty strings or spaces. But of course you could divide this more specific.

Datas:

LOAD OrderID,

     if(len(trim(ProductID)) = 0, 'NULL', ProductID) as ProductID,

     CustomerID,

     Amount,

     Date_updated

FROM

[incremental load.xlsx]

(ooxml, embedded labels, table is Sheet1);

- Marcus