Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Partner
Partner

Hi

Check below link. hope that helps.

QlikView Section Access Examples

Highlighted
Contributor III
Contributor III

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

Highlighted
Creator III
Creator III

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

Highlighted
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

Highlighted
Partner
Partner

Hi

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