Discussion Board for collaboration related to Qlik Education.
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 .
[ACCESS, USERID, PASSWORDadmin, a, 123user, b, 456]
[USERID,f1, f2a,1, 1b,0, 1]
in the condional opening option of sheets i am typing the condition if (sum (f1)=1)
I think this guide will help you do exactly what you want.
Section Access - Hide Sheet Level
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
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.
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
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.
I am glad you sorted it out.
I am sending you the script just in case
LOAD * INLINE [
ACCESS, USERID, PASSWORD
ADMIN, A, 123
USER, B, 456