Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Partner
Partner

Hi

Check below link. hope that helps.

QlikView Section Access Examples

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

Creator III
Creator III

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

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

Partner
Partner

Hi

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