Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Tab Access security

Hi All.

I am want to put some security into my model. I am amble to give section access but can someone please help me with tab access, as certain people only need to view certain tabs. I have tried the following

Section Access;

LOAD * INLINE [

    ACCESS, USERID, PASSWORD, SHEETS

    ADMIN, ADMIN, ADMIN123, *

    USER, USER1, 1, SH01,

    USER, USER1, 1, SH03

    USER, USER2, 2, SH06

    USER, USER3, 3, SH04

];

Section Application;

and

Section Access;

LOAD * INLINE [

    ACCESS, USERID, GROUP

    ADMIN, ADMIN1, GROUP1

    USER, USER1, GROUP2

    USER, USER2, GROUP3

];

 

Section Application;

LOAD * INLINE [

    GROUP, Sheets, flag

    GROUP1,SH01, 1

    GROUP1,SH02, 0

    GROUP2,SH01, 0

    GROUP2,SH02, 1

    GROUP3,SH01, 1

    GROUP3,SH02, 1

];

Thank you

4 Replies
manojkulkarni
Partner - Specialist II
Partner - Specialist II

go thru below link, might help

Sheets Security with Section Access

avinashelite

Hi Jean,

your code looks OK , what is the condition your using in the sheet properties to show and hide the tab??

can you please share that as well.

Anonymous
Not applicable
Author

sum(SH01)>=1

avinashelite

try like this:

sum({<Sheets={'SH01'}>}flag)>=1

follow same for other sheets change SH01 to SH02 etc

or try like

if(Sheets='SH01' and flag=1,1,0)