topic Re: Sheet Level Section Access not working in QlikView

Sheet Level Section Access not working

Thu, 03 Mar 2016 02:10:59 GMT

Hi Folks,

Sheet level Section access is not working,

1. EditScript > i created the script like below snippet.

2. Before applied the code i enable the "Initial Data reduction on section access" and "Strict Exclusion".

3. reload the data and closed it.

4. now i try to open with user login, but here it was showing 4 sheets.

can some one help me with this..

Thanks in advance..

@Sub2u444

Re: Sheet Level Section Access not working

jagan — Thu, 03 Mar 2016 03:14:41 GMT

Hi,

In every sheet you have to write a condition in

Sheet Properties -> General -> Show Sheet ->

For SH01:

Only({<SHEETID={'SH01'}>} USERID)

For SH02:

Only({<SHEETID={'SH02'}>} USERID)

Re: Sheet Level Section Access not working

tresB — Thu, 03 Mar 2016 04:44:54 GMT

Try like:

To be precise:

Sheet Properties -> General -> Show Sheet ->Conditional : expression

For SH01:

=USERID=Only({<SHEETID={'SH01'}>} USERID)

For SH02:

=USERID=Only({<SHEETID={'SH02'}>} USERID)

Re: Sheet Level Section Access not working

Thu, 03 Mar 2016 05:33:43 GMT

Hi,

I used the below condition, its not working.

=Only({<SHEETID={'SH01'}>} USERID) -- Sheet1

=Only({<SHEETID={'SH02'}>} USERID) -- Sheet2

Regards,

Sub2u444

Re: Sheet Level Section Access not working

Thu, 03 Mar 2016 05:33:53 GMT

Hi,

I used the below condition, its not working.

=Only({<SHEETID={'SH01'}>} USERID) -- Sheet1

=Only({<SHEETID={'SH02'}>} USERID) -- Sheet2

Regards,

Sub2u444

Re: Sheet Level Section Access not working

tresB — Thu, 03 Mar 2016 05:39:45 GMT

But I suggested something different:

=USERID=Only({<SHEETID={'SH01'}>} USERID)

Your expressing is missing the '=USERID=' part.

Re: Sheet Level Section Access not working

Thu, 03 Mar 2016 06:17:11 GMT

Hi Tresesco,

=USERID=Only({<SHEETID={'SH01'}>} USERID)

the above expression is working perfectly.

Thanks for your support.

Regards,

Sub2u444

Re: Sheet Level Section Access not working

jagan — Thu, 03 Mar 2016 06:33:12 GMT

Hi,

Hope this link helps you.

Sheet level access

If you got the answer close this thread by giving Correct and Helpful answers to the posts which helps you.

Regards,

Jagan.

Re: Sheet Level Section Access not working

Anonymous — Thu, 03 Mar 2016 06:44:19 GMT

your approach is right to create the section access