Skip to main content
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
greend21
Creator III
Creator III

Section Access to Show/Hide Sheet Issue

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

1 Solution

Accepted Solutions
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

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

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

View solution in original post

1 Reply
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

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

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!