Admin user should access NULL values

[qlikviewwizard]

Hi All,

I have a report. Users should be access data based on DNAME.

User1 (ADMIN) should access all the data - ACCOUNTS,HR,SALES.

User2 should access HR data.

User 3 should access SALES data.

But User1 should access NULL values always.

Please update the attached file and provide.

Thanks in advance.

[antoniotiman]

HI,

see attachment

Users/Psw

ADMIN/ADMIN

USER1/USER1

USER2/USER2

USER3/USER3

Regards,

Antonio

[qlikviewwizard]

Hi AntonioTiman

Thank you so much.It is perfect.

[jagan · Accepted solution]

Hi,

If user wants to access all the values other than then use *, to access nulls just give empty.

Section Access;

LOAD * INLINE [

    ACCESS, USERID, PASSWORD,DNAME

    ADMIN,ADMIN,ADMIN,*                // Access all values other than Nulls

    ADMIN,USER1,USER1,                   // To access values

    USER,USER2,USER2,HR

    USER,USER3,USER3,SALES

     USER,USER4,USER4,*

     USER, USER4, USER4, // USER4 can Access all values including nulls     

];

Section Application;

Hope this helps you.

Regards,

Jagan.

[qlikviewwizard]

Hi jagan

Thank you so much. It is working for NULLs also.