Qlik Community

Qlik Sense Deployment & Management

Discussion board where members learn more about Qlik Sense Installation, Deployment and Management.

joeybird
Contributor II

Qlik Sense - Sheet Access

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

8 Replies
MVP
MVP

Re: Qlik Sense - Sheet Access

How are you controlling the visibility of the sheets?

joeybird
Contributor II

Re: Qlik Sense - Sheet Access

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

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

joeybird
Contributor II

Re: Qlik Sense - Sheet Access

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

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 ??

joeybird
Contributor II

Re: Qlik Sense - Sheet Access

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

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

joeybird
Contributor II

Re: Qlik Sense - Sheet Access

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

Community Browser