topic Re: Tab Access security in QlikView

Tab Access security

Anonymous — Tue, 14 Apr 2015 12:45:46 GMT

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

Re: Tab Access security

manojkulkarni — Tue, 14 Apr 2015 12:51:46 GMT

go thru below link, might help

Sheets Security with Section Access

Re: Tab Access security

avinashelite — Tue, 14 Apr 2015 12:55:15 GMT

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.

Re: Tab Access security

Anonymous — Tue, 14 Apr 2015 12:57:49 GMT

sum(SH01)>=1

Re: Tab Access security

avinashelite — Tue, 14 Apr 2015 13:03:51 GMT

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)