topic Re: Re: Re: contidional hiding of sheets in Qlik Learning Discussions

contidional hiding of sheets

Thu, 18 Sep 2014 07:24:13 GMT

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)

Re: contidional hiding of sheets

Agis-Kalogiannis — Thu, 18 Sep 2014 12:07:53 GMT

Hi Arushi

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

Section Access - Hide Sheet Level

Regards

Agis

Re: Re: contidional hiding of sheets

Thu, 18 Sep 2014 13:08:56 GMT

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

Re: Re: Re: contidional hiding of sheets

Agis-Kalogiannis — Thu, 18 Sep 2014 17:06:03 GMT

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

Re: Re: Re: contidional hiding of sheets

Fri, 19 Sep 2014 06:04:24 GMT

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

Re: Re: Re: contidional hiding of sheets

Fri, 19 Sep 2014 06:17:41 GMT

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

Re: contidional hiding of sheets

Agis-Kalogiannis — Fri, 19 Sep 2014 11:54:31 GMT

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