topic Re: section access in QlikView

section access

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

Hi Experts,

I have 3 country's called INDIA, USA,UK and 30 user are there and each country belongs to 10 users

Now my requirement is if the india user logged in then can able to see the data for india and

if the USA user is logged in then can able to see the data for USA.

For this how to provide the section access without inline load with optimization.

Can you please help me on the same?

Chanty4u — Wed, 27 Jun 2018 07:31:53 GMT

vijetas42 — Wed, 27 Jun 2018 10:00:30 GMT

It's a straight forward. create an excel where you can maintain ACCESS,NTNAME,REGION

e.g. ADMIN,DOMAIN\USER_ID,*

USER,DOMAIN\USER_ID,USA

and in qlikview you just have to load excel in section access script

like,

SECTION ACCESS;

load excel file;

section application;

make sure REGION field name should be same in section access excel and your data.

Regards,

Vijeta