Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
chiranjivdas
Contributor III
Contributor III

Section Access based on value

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,

CD

5 Replies
krishnacbe
Partner
Partner

Hi

Check below link. hope that helps.

QlikView Section Access Examples

chiranjivdas
Contributor III
Contributor III
Author

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,

CD

Access Table.PNG

Access Script.PNG

vikramv
Creator III
Creator III

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

maxgro
MVP
MVP

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

Remember to backup the .qvw before!

This can also help

Introduction to Section Access

1.png

krishnacbe
Partner
Partner

Hi

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