Struggling to get anything working with section access

[fzalexanderjohn]

I'm trying to get a test-app with section access to work.

Unqualify *;

KNVPREDUCED:

LOAD KUNNR,

KUNNR as KUNNR2,

VKORG as REDUCTION

FROM [lib://qvd-Dateien (xxx_qlik-admin)/KNVP.qvd]

(qvd);

Section Access;

LOAD * INLINE [

ACCESS,USERID,REDUCTION

ADMIN,AD-DOMAIN\USER1, 1500

USER,AD-DOMAIN\QLIK1, 1400

];

section application;

But when User QLIK1 tries to access to app, there' an "access denied". Also, when user1 tries to access the app, the data with VKORG 1500 is still visiable.

Thanks!

[dwforest]

you've defined the first user with ADMIN, so they get everything.

section access does not control access to the app, make sure QLIK1 is setup with access and token.

[fzalexanderjohn]

Thanks for your reply.

When I change the Admin to User, I also get access denied. user1 also owns the app. I get access denied even though it isn't published yet.

I also checked and confirmed that we have qlik sense enterprise. Is it possible that we still working with the trial license? Our productive license is on the way though.

[agigliotti]

take a look here working with SA in Qliksense qmc

i think it could be useful for you.

[jonathandienst · Accepted solution]

Does VKORG 1400 exist?

Also check the data types in the QVD. Create a list box with REDUCTION - do 1400 and 1500 appear twice in the list box? That would mean they are different types and '1400' is not equal to 1400.

[fzalexanderjohn]

I tested this by removing the section access and section application parts and just joining the two tables "regularly". The association happened as expected. Unless the association with section access works totally different, the data-types should be fine.

The values 1400 and 1500 also both exist only once and when I select USER1 as a filter (when I remove the section access parts), I also do get only the values that the user should be seing later on.

[fzalexanderjohn]

You were right all along. When I converted the field to a number via num#(VKORG), it worked.

I do not know how my association-test did work without it.

Thanks!