Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
greend21
Contributor 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
Highlighted
MVP & Luminary
MVP & Luminary

Re: Section Access to Show/Hide Sheet Issue

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

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".

View solution in original post

1 Reply
Highlighted
MVP & Luminary
MVP & Luminary

Re: Section Access to Show/Hide Sheet Issue

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

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".

View solution in original post