Qlik Community

QlikView Security & Governance

Discussion Board for collaboration on QlikView Security and Governance.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
stabben23
Honored Contributor

Sheet Access in Access Point

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))

sheetaccess.png

5 Replies
ali_hijazi
Honored Contributor

Re: Sheet Access in Access Point

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

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

stabben23
Honored Contributor

Re: Sheet Access in Access Point

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).

stabben23
Honored Contributor

Re: Sheet Access in Access Point

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

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

stabben23
Honored Contributor

Re: Re: Sheet Access in Access Point

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.

Community Browser