Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
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

1 Solution

Accepted Solutions
raghvendrasingh
Creator II
Creator II

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

View solution in original post

5 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

Have a look at the Section Access in Qlik.

QlikView Section Access Examples

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Chanty4u
MVP
MVP

beck_bakytbek
Master
Master

raghvendrasingh
Creator II
Creator II

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
Not applicable
Author

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