Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hello,
I have 150 countries .But country manager cant see all the countries data except 3 countries .how can you implement this
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
Hi,
Have a look at the Section Access in Qlik.
QlikView Section Access Examples
Regards,
Kaushik Solanki
chk dis
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
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