Qlik Community

QlikView Security & Governance

Discussion Board for collaboration on QlikView Security and Governance.

Not applicable

Section access help

hello,

I have 150 countries .But country manager cant see  all the countries data except 3 countries .how can you implement this

Tags (1)
1 Solution

Accepted Solutions
raghvendra_singh
Contributor II

Re: Section access help

Hi,

Access,  UserID,  Password,  Country

USER,  USER,  USER, COUNTRY1

USER,  USER,  USER, COUNTRY2

USER,  USER,  USER, COUNTRY3

As per the above code, you can give multiple rows for giving the access of multiple countries.

If you want give the access for all countries to particular admin user, then you can write like as:

Access,  UserID,  Password,  Country

USER,  USER,  USER, *

Hope it will help.

Thanks,

Raghvendra

5 Replies

Re: Section access help

Hi,

Have a look at the Section Access in Qlik.

QlikView Section Access Examples

Regards,

Kaushik Solanki

sureshqv
Esteemed Contributor III

Re: Section access help

beck110979
Valued Contributor III

Re: Section access help

raghvendra_singh
Contributor II

Re: Section access help

Hi,

Access,  UserID,  Password,  Country

USER,  USER,  USER, COUNTRY1

USER,  USER,  USER, COUNTRY2

USER,  USER,  USER, COUNTRY3

As per the above code, you can give multiple rows for giving the access of multiple countries.

If you want give the access for all countries to particular admin user, then you can write like as:

Access,  UserID,  Password,  Country

USER,  USER,  USER, *

Hope it will help.

Thanks,

Raghvendra

geminihzh
Valued Contributor

Re: Section access help

Hi,

If you have more

Section Access;

LOAD * INLINE [

  ACCESS, NTNAME, NWGROUP

  ADMIN, MANAGER, ALL

  ADMIN, admin01, ALL

  USER, user01, GROUP1

  ...

];

script part 1:

Section Application;

AUTHLINK:

LOAD * INLINE [

NWGROUP, COUNTRY

USER1, Country1

...

]; // specific cases


script part 2:

CONCATENATE (AUTHLINK)

LOAD

     if (USER ...) as NWGROUP,

     Country

FROM CLIENT.qvd (qvd); //Load all clients, even for the clients are not in Section Access table yet

script part 3:

CONCATENATE (AUTHLINK)

LOAD

     'ALL' as NWGROUP,

     Country;

Select country from table where country not in (country_a, country_b, country_c);


country_a, country_b, country_c are the country you do not want the manager to have access.


You can check the "*" usage case from the discussion here.  You can use "*" if the countries except the 3 are assigned in the section access. Then you can change the section access as below to give the manger access.

Section Access;

LOAD * INLINE [

  ACCESS, NTNAME, NWGROUP

  ADMIN, MANAGER, *

  ADMIN, admin01, ALL

  USER, user01, GROUP1

  ...

];


Hope this helps.


Zhihong

Community Browser