topic Sheet Level Security - Conditional Show in QlikView

Sheet Level Security - Conditional Show

Mon, 27 Feb 2012 19:18:03 GMT

I am using NT security for Section Access and need to set up a conditional show expression to only show the "Details" sheet if "LEVEL" = "DETAIL".

See my section access code below:

Section Access;

LOAD * INLINE [

ACCESS, NTNAME, LEVEL

USER, iwavetwo\jrush, DETAIL

USER, iwavetwo\dstein,

ADMIN, iwavetwo\bash, DETAIL

];

Section Application;

Does anyone know how to make this happen?

Re: Sheet Level Security - Conditional Show

Mon, 27 Feb 2012 19:54:50 GMT

Hi,

Try This:

SECTION ACCESS;

LOAD * INLINE [

ACCESS, USERID, LEVEL

USER, 1, DETAIL

USER, 2,NO_DETAIL

ADMIN, 3, DETAIL

];

Section Application;

LOAD * INLINE [

LEVEL,VALID

DETAIL, 1

NO_DETAIL,0

];

And then in the Conditional Show: sum(VALID)>0

See the attach example.

Hope it help.

Re: Sheet Level Security - Conditional Show

Mon, 27 Feb 2012 23:10:44 GMT

Yigal BO wrote:
Hi,
Try This:
SECTION ACCESS;
LOAD * INLINE [
    ACCESS, USERID, LEVEL
    USER, 1, DETAIL
    USER, 2,NO_DETAIL
    ADMIN, 3, DETAIL
];
Section Application;
LOAD * INLINE [
    LEVEL,VALID
    DETAIL, 1
    NO_DETAIL,0
];
And then in the Conditional Show: sum(VALID)>0
See the attach example.
Hope it help.

Thanks for your reply, Yigal BO.

This is the correct approach, but I found out it does not work until you turn on the check box, "Initial Data Reduction using Section Access." It worked for me after checking that box. Also, I turned Strict Exclusion on.

Re: Sheet Level Security - Conditional Show

Tue, 16 Jul 2013 12:31:34 GMT

Hi brandoncash,

If i have less than 10 user it is fine.

suppose i have 1000 users, then what will we do...

Thanks.........