Section access for a whole table in data load editor

[#1]

Hi All,

I am using Qlik Sense. Our sheets has more than one dealer in it and share the same visuals so I have been trying to limit certain dealer to see his portion only of the visuals by using section access but that limits fields and I want to limit whole tables. I have tried the reduction and omit didn't work.

I don't want the limitations to be done in QMC I want it done in data load editor inside the app. Any ideas ?

Thanks in advance

[ift_isabelle]

We use Section Acces on de customerID. And does exactly what we want it to do:

section access;

LOAD * inline [

ACCESS, USERID, REDUCTION

ADMIN, <Servername>\ADMIN,*

USER, <Servername>\DEMO,123456

ADMIN, INTERNAL\SA_SCHEDULER,*

];

section application;

Servername as in the adress where you open the hub/qmc.

This code is in the first section after the parameters. After this my application load start.

What code dit you try?

I don't know how the Omit works, but maybe you can just make a selection on dealerID, so he can only see his own data?

[martinpohl]

it isn't possible to hide charts or tables.

But you can hide sheets by securtiy role

Find an example here

Concrete answer on creating security rule at stream sheet level

although you don't want, QMC is the only possibility

[jayaseelan]

Hi,

  It is possible in qlik view not in qlik sense.

Please refer the following documents will give you some ideas.

Thanks,

[#5]

Thanks for replying I tried a way that somehow gave an acceptable level which I used the following

Section Access;

[ACCESS,USERID,SERIALNUMBER

User,Xy\noha,4563

];

Section Application;

File name

and the serial number was the serial number of each company in this sheet so only the user with the USERID stated will see information linked to the that serial number and the result is acceptable.

[#6]

Thanks for replying I tried a way that somehow gave an acceptable level which I used the following

Section Access;

[ACCESS,USERID,SERIALNUMBER

User,Xy\noha,4563

];

Section Application;

File name

and the serial number was the serial number of each company in this sheet so only the user with the USERID stated will see information linked to the that serial number of the dealer and the result is acceptable.