Sheets security on user groups

[#1]

Hi all.

I would like to use sheets security on a applikation and I use user groups beacuse I have amny users.

How to solve this and what is the best way to hide sheets is it with section access or is ther any other solutions what doesn't needs to use userid and password?

Thanks!

[Anonymous]

Hi,

http://community.qlik.com/docs/DOC-1853

http://community.qlik.com/docs/DOC-6417

Hope this helps

[vikasmahajan]

PFA Documentation with demo.

Vikas

[#4]

The question is, could I use this in my script and the use the show sheet conditional as sum(SH01)>=1 on each sheet. I would like to use NTNAME and is it possible to use groups?

LOAD * INLINE [

    ACCESS, NTNAME

    ADMIN, ABA/tonys

    USER, ABA/app-qlikview-bi-controller

    USER, ABA/app-qlikview-bi-leader

];

Section Application;

LOAD * INLINE [

    NTNAME, Sheets, Flag

    ABA/tonys,SH67, 1

    ABA/tonys,SH105, 1

    ABA/tonys,SH108, 1

    ABA/tonys,SH111, 1

    ABA/tonys,SH110, 1

    ABA/app-qlikview-bi-controller,SH67, 1

    ABA/app-qlikview-bi-controller,SH105, 1

    ABA/app-qlikview-bi-controller,SH108, 1

    ABA/app-qlikview-bi-controller,SH111, 0

    ABA/app-qlikview-bi-controller,SH110, 0

    ABA/app-qlikview-bi-leader,SH67, 1

    ABA/app-qlikview-bi-leader,SH105, 1

    ABA/app-qlikview-bi-leader,SH108, 1

    ABA/app-qlikview-bi-leader,SH111, 1

    ABA/app-qlikview-bi-leader,SH110, 0

];

[#5]

hi please check this appln

[#6]

My script looks like below but I don´t get any prompt when I relaod och publish.

Do I need to do anything in the QMC?

SECURITY:

LOAD * INLINE [

    ACCESS, NTNAME, USER, PASSWORD

    ADMIN, ABA/tonys, ADMIN, ADMIN

    USER, ABA/app-qlikview-bi-controller, SC, SC

    USER, ABA/app-qlikview-bi-leader, SLG, SLG

];

Section Application;

SHEET_ACCESS:

LOAD * INLINE [

    USER, SHEET1, SHEET2, SHEET3, SHEET4, SHEET5, SHEET6, SHEET7, SHEET8, SHEET9, SHEET10, SHEET11, SHEET12, SHEET13, SHEET14

    ADMIN, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1

    SC, 1, 1, 1, 0, 0, 1, 1, 1, 1, 1, 1, 1, 1, 1

    SLG, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1

];