Section access help

[#1]

hello,

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

[kaushiknsolanki]

Hi,

Have a look at the Section Access in Qlik.

QlikView Section Access Examples

Regards,

Kaushik Solanki

[Chanty4u]

chk dis

A Primer on Section Access

[beck_bakytbek]

hi Kalavathis

check this : QlikView Document Level Security Settings - YouTube

beck

[raghvendrasingh · Accepted solution]

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

[Anonymous]

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