topic Re: section access mask in QlikView

section access mask

ramachandra_gee — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: section access mask

ramachandra_gee — Mon, 03 Jul 2017 04:37:49 GMT

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

Thanks,

Ram.

Re: section access mask

Anonymous — Mon, 03 Jul 2017 06:37:37 GMT

Have a look:

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

Implement Row level Security:

Authentication and Authorization in Qlikview

Hope it helps!!

Re: section access mask

ramachandra_gee — Mon, 03 Jul 2017 07:10:36 GMT

Thanks for your quick reply,

but this is not the actual requirement.

Thanks,

Ram.

Re: section access mask

jmvilaplanap — Mon, 03 Jul 2017 08:46:44 GMT

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

Re: section access mask

ramachandra_gee — Mon, 03 Jul 2017 11:24:25 GMT

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

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

Re: section access mask

arvind_patil — Mon, 03 Jul 2017 11:32:28 GMT

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

Re: section access mask

jmvilaplanap — Mon, 03 Jul 2017 11:34:47 GMT

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

Re: section access mask

arvind_patil — Mon, 03 Jul 2017 11:43:15 GMT

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