Qlik Community

QlikView Security & Governance

Discussion Board for collaboration on QlikView Security and Governance.

karloss11
Contributor

Security

Hi all,

I am trying to set up security around my document and I'm having a little trouble.

For simplicity sake, lets say I have two tabs in my document. 1 that has Stock data and 1 that has finance data. I want everyone to be able to see the data on the stock tab but restrict what data people can see on the finance tab.

When I use section access and check the initial data reduction option, this excludes the data on the finance tab as expected but also it removed all data on the stock tab (The finance and stock data are only linked via the IndexDate field)

Ultimately I want to have the following:

Full Table

Area                    Cost Type          Amount

Area A                Staff                    £50

Area A               Materials               £100

Area B               Staff                    £150

Area B               Materials               £200

I want to be able to restrict the above table to have the following results

Manager A

Area                    Cost Type          Amount

Area A                Staff                    £50

Area A               Materials               £100

User A

Area                    Cost Type          Amount

Area A               Materials               £100

Manager B

Area                    Cost Type          Amount

Area B               Staff                    £150

Area B               Materials               £200

User B

Area                    Cost Type          Amount

Area B               Materials               £200

That is, that Each manager can see the full costs for their area only and each user can see all the costs except staff costs for their own area only.

I hope this makes sense. Thanks, Karl

5 Replies
Employee
Employee

Re: Security

Hi,

Here is a sample QVS. The logins are:

ADMIN

MANAGERA

USERA

MANAGERB

USERB

Bill

karloss11
Contributor

Re: Security

Thanks for the work Bill, but as mentioned in my post - I can get the section access to work (and it works fine for simple examples) but in my real document it excludes data that I dont want it to. i.e. it excludes all the Stock data as (in my example above) that data isnt linked to a specific manager or area.

Employee
Employee

Re: Security

Hi,

Hard to say what the issue is without the data.

Bill

vikasmahajan
Honored Contributor III

Re: Re: Security

PFA  Document Please refer the same using login admin and password admin1

Hope this may help you what you are looking for.

Vikas

karloss11
Contributor

Re: Security

All,

Thanks for the help. I've resorted to creating variables based on the OSUSer() and then applying the set analysis on the objects I want based on those variables.

Community Browser