Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

Section access for a whole table in data load editor

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

5 Replies
ift_isabelle
Not applicable

Re: Section access for a whole table in data load editor

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
Not applicable

Re: Section access for a whole table in data load editor

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
Not applicable

Re: Section access for a whole table in data load editor

Hi,

  It is possible in qlik view not in qlik sense.

Please refer the following documents will give you some ideas.

Thanks,

Not applicable

Re: Section access for a whole table in data load editor

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.

Not applicable

Re: Section access for a whole table in data load editor

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.