topic Re: Sheet Access in Access Point in QlikView

Sheet Access in Access Point

stabben23 — Mon, 26 Jan 2026 18:19:17 GMT

Hi I have a very annoying problem, see picture. I want to show sheet using Section Access, and it works in 3 of 4 cases.

But the problem is that it dont works in Access Point and that's what the customer use. Is this a bug? I use 11.20 SR5.

It's just Margin tab that is using show sheet conditional and in this case it should be 1.

The formula in show sheet conditional is =sum(if(upper(OSUser())=NTNAME,1))

Re: Sheet Access in Access Point

ali_hijazi — Wed, 01 Oct 2014 09:01:41 GMT

put the upper(OSUser())=NTNAME in a text box

does it really return true? cause I see diverse selections in your screenshots

Re: Sheet Access in Access Point

stabben23 — Wed, 01 Oct 2014 09:18:22 GMT

The selection has nothing to do with it, but it seams that the conditional is false=0.

I think that the problem is that I have no selection in my field NTNAME (that comes from my Section Access).

In Document Properties-->Opening I have nothing selected in Section Access area(checkboxes).

Re: Sheet Access in Access Point

stabben23 — Wed, 01 Oct 2014 09:30:36 GMT

Should I use a trigger OnOpen that puts NTNAME=OSuser() when opening the document?

Is that a solid solution?

Re: Sheet Access in Access Point

ashfaq_haseeb — Wed, 01 Oct 2014 09:58:43 GMT

Hi,

This sound to be strange.

Make sure the highlighted content in attached image is selected.

Check if this helps

http://community.qlik.com/docs/DOC-4435

Regards

ASHFAQ

Re: Re: Sheet Access in Access Point

stabben23 — Thu, 02 Oct 2014 09:49:34 GMT

If I select "Initial Data reduction Based on Section Access" and "Strict Execlusion" it keeps all ADMIN users in NTNAME when I open report. "Initial Selection Based on Section Access" will select ADMINs in field NTNAME when open the report all other is visible but unselected.

"Initial Data reduction Based on Section Access" and "Strict Execlusion" I thought that only my NTNAME should be keept when open report.