Qlik Community

QlikView Security & Governance

Discussion Board for collaboration on QlikView Security and Governance.

Highlighted
Arjunarao
Honored Contributor II

Admin user should access NULL values

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.

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Admin user should access NULL values

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.

4 Replies
antoniotiman
Honored Contributor III

Re: Admin user should access NULL values

HI,

see attachment

Users/Psw

ADMIN/ADMIN

USER1/USER1

USER2/USER2

USER3/USER3

Regards,

Antonio

Arjunarao
Honored Contributor II

Re: Admin user should access NULL values

Hi AntonioTiman

Thank you so much.It is perfect.

MVP & Luminary
MVP & Luminary

Re: Admin user should access NULL values

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.

Arjunarao
Honored Contributor II

Re: Admin user should access NULL values

Hi jagan

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