topic Re: Section Access based on value in QlikView

Section Access based on value

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

I have created a qlikview that shows revenue by product division. There are three divisions: A, B and C.

I want to restrict access to the data, i.e., Tom, who is the GM of division A should only be able to see data pertaining to division A. Similarly, Sally, who is the GM of division B should only have access to division B data.

Is it possible to do this in the load script? Could you please share the syntax?

Thanks,

Re: Section Access based on value

krishnacbe — Fri, 15 Jul 2016 16:12:33 GMT

Check below link. hope that helps.

QlikView Section Access Examples

Re: Section Access based on value

chiranjivdas — Fri, 15 Jul 2016 18:44:20 GMT

This helped in creating the userid and password prompt. But the data is not being restrictive as far as division is concerned. In other words, I created the following access table and script. But no matter who I log in as, I can see all divisions.

Thanks for your help,

Re: Section Access based on value

vikramv — Fri, 15 Jul 2016 18:58:34 GMT

Have you checked these option "Initial Reduction Based On section access" + "Strict Exlusion" checked under Settings --> Document Properties -- > Opening ?

Re: Section Access based on value

maxgro — Fri, 15 Jul 2016 19:02:20 GMT

Did you check these in Settimgs --> Document Properties --> Opening ?

Remember to backup the .qvw before!

This can also help

Introduction to Section Access

Re: Section Access based on value

krishnacbe — Fri, 15 Jul 2016 19:11:28 GMT

As insisted by Vikram and Maxgo you should enable the Dtrick Exclusion option.