topic Re: Section access help in QlikView

Section access help

Mon, 26 Jan 2026 18:19:17 GMT

hello,

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

Re: Section access help

kaushiknsolanki — Mon, 01 Aug 2016 07:42:55 GMT

Hi,

Have a look at the Section Access in Qlik.

QlikView Section Access Examples

Regards,

Kaushik Solanki

Re: Section access help

Chanty4u — Mon, 01 Aug 2016 09:07:18 GMT

chk dis

A Primer on Section Access

Re: Section access help

beck_bakytbek — Mon, 01 Aug 2016 09:09:40 GMT

hi Kalavathis

check this : QlikView Document Level Security Settings - YouTube

beck

Re: Section access help

raghvendrasingh — Mon, 01 Aug 2016 09:50:55 GMT

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

Re: Section access help

Anonymous — Fri, 12 Aug 2016 08:21:32 GMT

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