sheet access

[omid5ive]

hi

i have a table with two filed:
1- user name

2- user group

and

i have a qlikview document with multi tab

i need this:
when some one login to my dasboard just can see the sheet that it has permission to see it
how can i do it?

[Anonymous]

You could try the conditional show / hide on the properties of the sheet you wish to show / hide exploiting the OSuser() function.

[its_anandrjs]

Put Sheet level section access on your Qlik Document.

Regards,

Anand

[omid5ive]

would you please send me en example?

[sergio0592]

Check this out :  https://community.qlik.com/docs/DOC-9039

[its_anandrjs]

You can search for this on the Qlik Community there are many post related to this.

Regards,

Anand

[raghvendrasingh]

Hi Omid,

Please go through the link,I hope  it will be helpfull to you.

Sheet Level Security.qvw

Thanks,

Raghvendra

[Anil_Babu_Samineni]

I Agree with Anand, You will get more stuff on google,

For reference

[Sheet Level Access]:

UserName, Sheet1 .... Sheetn

A, 1, ...., 0

B, 1, ....., 1

C, 1, ..... 1

D, 0 ,,,,, 0

So, Here 1 and 0 Means { 1- Access and o- Don't access }

[jagan]

Hi,

Check this link

Sheet level access

Hope it helps you.

Regards,

Jagan.

[marjan_it]

you an define a field in your script and make condition in show sheet, then in section access refer to each user accessId for sheet. in sample attachement you should refer AccessId=1 in user that should see sheet1 and refer AccessId=2 in user that should see sheet2.