topic Re: QlikView 11 Section Access in QlikView

QlikView 11 Section Access

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi!

I work QlikView 11.2 SR15 in section access not found, when User1 apply filters * in ☺[%PROY_ID] but User2 apply the filters correct

LOAD * INLINE [

ACCESS, NTNAME, %PROY_ID

ADMIN, Domain\ADMINISTRATOR, *

ADMIN, Domain\User1, *

USER, Domain\User2, 1

];

Section Application;

Reggards

Re: QlikView 11 Section Access

Anil_Babu_Samineni — Thu, 09 Mar 2017 18:29:03 GMT

May be

LOAD * INLINE [

ACCESS, NTNAME, %PROY_ID

ADMIN, Domain\ADMINISTRATOR, *

USER, Domain\User1, *

USER, Domain\User2, 1

];

Section Application;

Re: QlikView 11 Section Access

Anonymous — Thu, 09 Mar 2017 18:35:29 GMT

Tanks Anil,

I apply the change but User1 Filter %PROY_ID with value 1. If I change the value 2 apply the filter correct the * not found.

Re: QlikView 11 Section Access

Peter_Cammaert — Thu, 09 Mar 2017 21:14:00 GMT

The asterisk (*) does mean all values, but only those that appear in the same field in this single Section Access table. Not those that may also appear in the corresponding Section Application field.

If * should mean all values in my entire data model, you'll need to either map them to some other value (for example 'ALL' that links to all %PROY_ID values in Section Application), or add dummy rows to the Section Access table with all other %PROY_ID values.