Section Access to Show/Hide Sheet Issue

[greend21]

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

[kaushiknsolanki · Accepted solution]

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