section access mask

[ramachandra_gee]

Hi Hunters,

I have a requirement in the section access like below.

input.

site	state	disitnct	sales
India	ap	ongole	80
India	ap	nell	85
india	bhp	paradise	23
india	bhp	cellorium	45
us	remedy	calom	86
us	remedy	siral	75
kenada	kalosa	richel	66
kenada	kalosa	silaj	89
kenada	sumera	aparlak	25
non-south	pradesh	kilkut	36
non-south	pradesh	suraj	25

output for admin.

site	state	disitnct	sales
India	ap	ongole	80
India	ap	nell	85
india	bhp	paradise	23
india	bhp	cellorium	45
us	remedy	calom	86
us	remedy	siral	75
kenada	kalosa	richel	66
kenada	kalosa	silaj	89
kenada	sumera	aparlak	25
non-south	pradesh	kilkut	36
non-south	pradesh	suraj	25

out put for who is having india access

site	state	disitnct	sales
India	ap	ongole	80
India	ap	nell	85
india	bhp	paradise	23
india	bhp	cellorium	45
site2	remedy	default	86
site2	remedy	default	75
site3	kalosa	default	66
site3	kalosa	default	89
site3	sumera	default	25
non-south	pradesh	kilkut	36
non-south	pradesh	suraj	25

out put for  who is having us access

site	state	disitnct	sales
site1	ap	default	80
site1	ap	default	85
site1	bhp	default	23
site1	bhp	default	45
us	remedy	calom	86
us	remedy	siral	75
site3	kalosa	default	66
site3	kalosa	default	89
site3	sumera	default	25
non-south	pradesh	kilkut	36
non-south

[ramachandra_gee]

Please call me to this number(9710463111), if you get a solution.

Thanks,

Ram.

[Anonymous]

Hi

Have a look:

https://community.qlik.com/docs/DOC-16199‌

Implement Row level Security:

Authentication and Authorization in Qlikview

Hope it helps!!

[ramachandra_gee]

Thanks for your quick reply,

but this is not the actual requirement.

Thanks,

Ram.

[jmvilaplanap]

Could you explain a little bit more about the requirements?

As I see, you only need the section access table with users and a column with sites to link to this table, but I think I need more information to give my opinion

Regards

[ramachandra_gee]

Hi,

when I log in as admin I need to see all the data with out mask.

if I log in as a user I need to see the data which I have access other data should be mask.

ex:

site

india

us

kenada

userid  acess

chandu ,admin

balu, ,india

Krishna  us

ram,kenada

If I log in as admin access I need to see all the data,

if I log in as a balu user I need to see india and other information should be site2,site3

Thanks,

Ram

[arvind_patil]

Hi Ramachandra,

Please Generate Master Excel for All unique Site Data.

and pass sites to the user according to their role. like Admin all site, who have the limited access pass only those.

Thanks,

Arvind Patil

[jmvilaplanap]

Then you must to add the site column to the section access

access, userid, site

admin, chandu, *

user, balu, india

user, Krishna, us

user, ram, jenada

remember that you need to have all the sites in the table to use the *, if you have some sites that are accessible only for the admin, you can add lines like that

dummy, dummy, france

dummy, dummy, spain

Regards

[arvind_patil]

Hi  Jose,

You are Right, But  make sure when you assign * against someone then all other site values cover in that column other wise it display only for available column.

Thanks,

Arvind Patil