Section Access to Show/Hide Sheet Issue

greend21 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I'm testing using Section Access to show/hide certain sheets and I am having some trouble, even when following someone else's example qvw. I've attached my test here. As soon as I add a condition to Sheet 2 it hides it no matter what user I am logged in as. The expression in the condition is one I saw in an example but I also tried using something as simple as Showfield=1. Even when logged in as a user within Group U it will still hide sheet 2. Sheet 2 remains hidden in the example below no matter who you log in as. Do you have any idea why this is not working?

The password to view the hidden script is "test" and the script is as follows:

Section Access;
LOAD * INLINE [
ACCESS, USERID, GROUP
ADMIN, DG, U
USER, DG1, U
USER, DG2, O
];

Section Application;
LOAD * INLINE [
GROUP,SH0WFIELD
U,1
O,0
];

Thanks in advance,

Dan

Re: Section Access to Show/Hide Sheet Issue

kaushiknsolanki — Mon, 30 Oct 2017 08:46:12 GMT

Hi,

Try this condition

=If(Sum(SH0WFIELD)>=1,1,0)

Instead of Sum(Group) >0

You can not get the sum of the text field and thus it is not working.

Regards,

Kaushik Solanki

topic Section Access to Show/Hide Sheet Issue in QlikView

Section Access to Show/Hide Sheet Issue

Re: Section Access to Show/Hide Sheet Issue