topic Re: Qlik Sense Section Access Table in App Development

Qlik Sense Section Access Table

navaneeth79 — Mon, 07 May 2018 11:03:04 GMT

Hi all,

Can anyone explain how to create a section access table for Qlik Sense Operations monitor Dashboard to view tasks of only particular dashboard.

Thanks in advance!!!!

Re: Qlik Sense Section Access Table

bramkn — Mon, 07 May 2018 11:23:57 GMT

As the Operations monitor is updated every upgrade. You should make a duplicate and put in section access in that app. And then just make the original one unavailable for users.

Re: Qlik Sense Section Access Table

navaneeth79 — Mon, 07 May 2018 11:29:42 GMT

I want to know how actually we can implement section access any example so that I can apply the same. I am new to Sense.

Re: Qlik Sense Section Access Table

navaneeth79 — Mon, 07 May 2018 11:30:30 GMT

I created duplicate of the app too. want to implement the table in the duplicate one

Re: Qlik Sense Section Access Table

bramkn — Mon, 07 May 2018 11:37:11 GMT

Tips and tricks for section access in Qlik Sense (2.0+)

Re: Qlik Sense Section Access Table

navaneeth79 — Mon, 07 May 2018 12:36:53 GMT

can we use a field name instead of reduction in section access table

Re: Qlik Sense Section Access Table

bramkn — Mon, 07 May 2018 12:43:39 GMT

You can use field values to state which data can be seen by which users. and you can omit fields by omiting the fieldname.

so in your case you would create a row for each person in combination with each app name he should be able to see. what field u need for that you can find in the monitoring app.

Re: Qlik Sense Section Access Table

navaneeth79 — Mon, 07 May 2018 13:31:27 GMT

I tried doing so but failed to get the required data, actually my requirement is that a particular user can also see data related to a field value and other data should be not seen. but when I implement I am getting error i.e., no sheets are visible for that user.

Re: Qlik Sense Section Access Table

bramkn — Mon, 07 May 2018 14:03:37 GMT

If you get that error, you are doing something wrong. Please provide the code so I/we kan see what you are doing wrong.

Your requirement is not very clear to me, so please provide a sample of what the outcome should be.

Re: Qlik Sense Section Access Table

navaneeth79 — Mon, 07 May 2018 15:17:59 GMT

‌in operations monitor we can see task details of every dashboard. So my requirement is that the user can only view task details of particular dashboard. For example if dashboard1, dashboard2 are two dashboards and user should only see tasks related to dashboard2.

my code is

LOAD * INLINE

[

ACCESS,USERID,APPNAME,OMIT

USER,ABC,DASHBOARD2,

]

Re: Qlik Sense Section Access Table

navaneeth79 — Mon, 07 May 2018 15:19:58 GMT

SECTION ACCESS;

‌LOAD * INLINE

[

ACCESS,USERID,APPNAME,OMIT

USER,ABC,DASHBOARD2,

]

Re: Qlik Sense Section Access Table

bramkn — Tue, 08 May 2018 06:19:00 GMT

don't forget that you need the actual UserID so with the domain. you can find this in the QMC at the user page. so use user directory\userID

Re: Qlik Sense Section Access Table

navaneeth79 — Thu, 10 May 2018 07:08:56 GMT

The section access is getting applied when the data is in CAPS but not when the data is in small letters, do we have anyway to apply Section Access even the data is in small letters.

Re: Qlik Sense Section Access Table

bramkn — Fri, 11 May 2018 06:20:47 GMT

always use UPPER for things like this. It will make sure that the data is linked properly. Create a second field with UPPER to use for SA. This way your normal data field wil show up normaly in dashboards and such.