topic Limited sheets with section access in QlikView

Limited sheets with section access

Anonymous — Fri, 20 Dec 2013 10:34:28 GMT

Hi everybody,

i have published on my Qlikview Server my QVW.

I'm using the SECTION ACCESS to limit the data visible by my client and works.

But this project is composed by multiple sheet and i would like to limit them to some of my client but i want to see them all.

How can i do?

Re: Limited sheets with section access

salto — Fri, 20 Dec 2013 10:49:33 GMT

Hi,

you can conditionally show every sheet.In the Sheet properties, General tab, you can check the "Conditional" checkbox under "Show Sheet". The condition could be something like:

=mixmatch(osuser(),'domain\user1',....,'domain\userN')

Which will show the sheet only if the user opening the document is one of the specified in the condition.

Hth.

Re: Limited sheets with section access

Peter_Cammaert — Fri, 20 Dec 2013 11:03:08 GMT

Ample information available in the community:

This one Sheets Security with Section Access links to a Salto-like method but also covers adding sheet security to a Section Access table.

In this discussion QVW sheet security Gysbert lists other sources of information.

Good luck,

Peter