Section Access based on value

[chiranjivdas]

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

[krishnacbe]

Hi

Check below link. hope that helps.

QlikView Section Access Examples

[chiranjivdas]

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

[vikramv]

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

[maxgro]

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

Remember to backup the .qvw before!

This can also help

Introduction to Section Access

[krishnacbe]

Hi

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