topic Re: Security in QlikView

Security

Karl_Hart — Mon, 26 Jan 2026 18:19:17 GMT

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

Re: Security

Bill_Britt — Wed, 29 Oct 2014 14:29:52 GMT

Hi,

Here is a sample QVS. The logins are:

ADMIN

MANAGERA

USERA

MANAGERB

USERB

Bill

Re: Security

Karl_Hart — Wed, 29 Oct 2014 14:46:13 GMT

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.

Re: Security

Bill_Britt — Wed, 29 Oct 2014 21:18:15 GMT

Hi,

Hard to say what the issue is without the data.

Bill

Re: Re: Security

vikasmahajan — Thu, 30 Oct 2014 06:22:00 GMT

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

Hope this may help you what you are looking for.

Vikas

Re: Security

Karl_Hart — Fri, 31 Oct 2014 16:49:20 GMT

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.