topic Re: sheet access in QlikView

sheet access

omid5ive — Sat, 24 Sep 2016 09:45:11 GMT

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?

Re: sheet access

Anonymous — Sat, 24 Sep 2016 09:48:48 GMT

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

Re: sheet access

its_anandrjs — Sat, 24 Sep 2016 10:48:23 GMT

Put Sheet level section access on your Qlik Document.

Regards,

Anand

Re: sheet access

omid5ive — Sat, 24 Sep 2016 10:54:26 GMT

would you please send me en example?

Re: sheet access

sergio0592 — Sat, 24 Sep 2016 11:05:23 GMT

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

Re: sheet access

its_anandrjs — Sat, 24 Sep 2016 11:28:26 GMT

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

Regards,

Anand

Re: sheet access

raghvendrasingh — Sat, 24 Sep 2016 11:49:10 GMT

Hi Omid,

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

Sheet Level Security.qvw

Thanks,

Raghvendra

Re: sheet access

Anil_Babu_Samineni — Sat, 24 Sep 2016 14:32:27 GMT

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 }

Re: sheet access

jagan — Sat, 24 Sep 2016 16:44:07 GMT

Hi,

Check this link

Sheet level access

Hope it helps you.

Regards,

Jagan.

Re: sheet access

marjan_it — Sun, 25 Sep 2016 05:24:01 GMT

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.