topic Re: Section Access NTNAME Conditional Show on Button in QlikView

Section Access NTNAME Conditional Show on Button

Tue, 31 Dec 2013 19:10:44 GMT

Trying to implement section access so only certain users are able to see a button when logging into the access portal.

Here is what i have scripted so far and this works for granting USER1 and USER2 access to the portal. For instance, a USER3 does not even see the access portal on the web.

SIACCESS:
LOAD * INLINE [
    SIACCESS
    Y
    N
];

Section Access;
LOAD * INLINE [
    ACCESS, NTNAME, SIACCESS
    ADMIN, USER1, Y
    USER, USER2, N
];
Section Application;

Now I have a button called (SI) with a conditional Show which looks like this:

if(SIACCESS='Y', 1, 0)

How do i get it so the "Y" or "N" from the section access user records tells the button to appear or not? Am i missing something in the Section Access area?

Re: Section Access NTNAME Conditional Show on Button

Nicole-Smith — Thu, 02 Jan 2014 15:09:25 GMT

Make sure you have the following option checked in Document Properties:

Re: Section Access NTNAME Conditional Show on Button

tseebach — Thu, 02 Jan 2014 15:15:24 GMT

The field SIACCESS would in many cases return more than 1 value. To check if this is the case, then create a textboject with the expression =SIACCESS

If thats the case, I would use if(Only(SIACCESS)='Y', 1, 0) instead. So there is a aggregation around the field.

Re: Section Access NTNAME Conditional Show on Button

Thu, 02 Jan 2014 15:21:17 GMT

thanks for this tip...this solved my issue.

Re: Section Access NTNAME Conditional Show on Button

Nicole-Smith — Thu, 02 Jan 2014 15:23:12 GMT

Great!