topic Re: Qlik Sense - Sheet Access in Management & Governance

Qlik Sense - Sheet Access

joeybird — Fri, 13 Nov 2015 11:47:23 GMT

Hiya

I have this code

Section Access;

SECURITY:
LOAD * INLINE [
ACCESS, NTNAME,              USER
ADMIN, TESTER\TESTER,
USER, TEST\TEST1,             TEST1
USER, TEST\TEST2,             TEST2

];

Section Application;

SHEET_ACCESS:
LOAD * INLINE [
    USER,    SHEET1, SHEET2
    TEST1,    1, 0
    TEST2,    0, 1
];

unfortunately both TEST 1 & 2 users can both see SHEET1 & SHEET2

please advise

Kind Regards

Re: Qlik Sense - Sheet Access

jonathandienst — Fri, 13 Nov 2015 11:49:01 GMT

How are you controlling the visibility of the sheets?

Re: Qlik Sense - Sheet Access

joeybird — Fri, 13 Nov 2015 11:51:09 GMT

Hiya

I want to say....

if user is TEST1, they see SHEET1...but cannot see SHEET2

if user is TEST2, they see SHEET2...but cannot see SHEET1

please help

Re: Qlik Sense - Sheet Access

rubenmarin — Fri, 13 Nov 2015 13:19:45 GMT

Hi Joanna, I think this can be controlled only by security rules if you have a Sense server.

Re: Qlik Sense - Sheet Access

joeybird — Fri, 13 Nov 2015 13:26:44 GMT

Hiya

I am doing this via a test server...

OMIT two feilds - section access

my preivious post with Section access worked, regarding omit fields. I have with the code, prevented certain data sets to be seen

my issue now I just need to now learn how to hide sheets

please help

OMIT two feilds - section access

Re: Qlik Sense - Sheet Access

rubenmarin — Fri, 13 Nov 2015 13:33:40 GMT

I haven't found that requirement yet so I don't have tried at sheet level, just apps and streams and in a simple way, maybe this post helps you to find the solution:

Sheet level Section Access in Qlik Sense ??

Re: Qlik Sense - Sheet Access

joeybird — Fri, 13 Nov 2015 15:39:27 GMT

Hiya

the PDF does not download... Sheet level Section Access in Qlik Sense ??

is there a chance this PDF is available on different link

... also have noticed this link

Section access on sheet level

in qlik sense - or is there an app version of this for qlik sense to download please

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD,PROFILE

admin, college, college,COLLEGE

user, physics, physics,PHYSICS

user, chemistry, chemistry,CHEMISTRY

user, maths, maths,MATHS

];

Section Application;

Profile:

LOAD * INLINE [

PROFILE, SH01, SH02, SH03, SH04

PHYSICS, 1, 1, 0, 0

CHEMISTRY, 1, 0, 0, 1

MATHS, 1, 0, 1, 0

COLLEGE, 1, 1, 1, 1

Then your show sheet condition would be like

SH02<>0 (where would I place this condition please)?

Kind Regards

Re: Qlik Sense - Sheet Access

rubenmarin — Mon, 16 Nov 2015 08:39:18 GMT

Hi Joanna, that's the QlikView version, in QlikView you can set the conditional show of the sheet based on those values.

I don't know where to get the pdf, but this is the link for sense help: https://help.qlik.com/sense/2.1/en-US/online/#Home.htm%3FTocPath%3D_____1

Re: Qlik Sense - Sheet Access

joeybird — Thu, 19 Nov 2015 15:57:09 GMT

Hiya

every time I try to download any PDF guide, I seem to come across broken links.

Is there a link please to a working step by step guide / Training Manual or you tube video aim directly at Sheet access, and Section Access?

Please help