QlikView 11 Section Access

[Anonymous]

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

[Anil_Babu_Samineni]

May be

LOAD * INLINE [

    ACCESS, NTNAME, %PROY_ID

    ADMIN, Domain\ADMINISTRATOR, *

    USER, Domain\User1, *

    USER, Domain\User2, 1

];

Section Application;

[Anonymous]

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.

[Peter_Cammaert · Accepted solution]

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.