topic Re: Null values and Session Access in QlikView

Null values and Session Access

Mon, 26 Jan 2026 18:19:17 GMT

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.

Re: Null values and Session Access

Colin-Albert — Fri, 06 Nov 2015 15:30:07 GMT

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

Re: Null values and Session Access

Sun, 08 Nov 2015 00:50:57 GMT

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

Re: Null values and Session Access

Mon, 09 Nov 2015 09:44:16 GMT

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 !

Re: Null values and Session Access

jfkinspari — Mon, 09 Nov 2015 10:08:47 GMT

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

Re: Null values and Session Access

jafari_ervin — Mon, 09 Nov 2015 10:11:57 GMT

please see the attachment.

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

Re: Null values and Session Access

marcus_sommer — Mon, 09 Nov 2015 10:13:29 GMT

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