Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

Not applicable

contidional hiding of sheets

hi everyone ,

i have a qlikview document with two tabs , i wish to hide one of the tabs for a particular user ,

i have tried doing this by using the section access option in the insert menu when we edit script ,

and then loading a table with the user ids and vaiables which i have used in the condional opening option in sheet properties.

still i am not able to hide the sheets .

please guide me through this .

Section 

Access;

LOAD

* INLINE

[
ACCESS, USERID, PASSWORD
admin, a, 123
user, b, 456
]

;

Section

Application

;

LOAD

* INLINE

[
USERID,f1, f2
a,1, 1
b,0, 1
]

;

in the condional opening option of sheets i am typing the condition if (sum (f1)=1)

6 Replies
Employee
Employee

Re: contidional hiding of sheets

Hi Arushi

I think this guide will help you do exactly what you want.

Section Access - Hide Sheet Level

Regards

Agis

Not applicable

Re: Re: contidional hiding of sheets

Hi Agis,

thanks for the guide .

unfortunately i am still not successful in doing the task ,i am attaching the required qlikview document .

please see and let me know where i am going wrong

Employee
Employee

Re: Re: Re: contidional hiding of sheets

Hi Arushi

Try this.

It works fine after a couple of modifications I did on the script.

The Hidden Script's password is 'a' (just the character a).

All the other credentials are the same.

Bear in mind that whatever we add in section access need to be in upper case, and the same implies also for the second table in the hidden script (in the Section Application part).

Please let me know if you need something else.

Regards

Agis

Not applicable

Re: Re: Re: contidional hiding of sheets

hey ,

i am using the personal edition , i cant view your file.

Is it  possible for you to copy the script and attach as a text document or paste it here

thanks and regards

arushi

Not applicable

Re: Re: Re: contidional hiding of sheets

Hey Agis,

i just converted everything into capitals in the section access and section application part .

i was successfully able to hide the tabs for required user.

Really appreciate your help.

thanks a ton.

Arushi Ahuja


Employee
Employee

Re: contidional hiding of sheets

Hi Arushi

I am glad you sorted it out.

I am sending you the script just in case

Section Access;

LOAD * INLINE [

    ACCESS, USERID, PASSWORD

    ADMIN, A, 123

    USER, B, 456

];

Section Application;

LOAD * INLINE [

     USERID,SHEETID

     A,SH01

     A,SH02

     B,SH02

];

Thanks

Agis

Community Browser