topic Reduction Fields in QlikView

Reduction Fields

Mon, 26 Jan 2026 18:19:17 GMT

Hi,

Im trying to make a reduction on a specific field for diferents users. I did it, but i have the following problem.

Im using the personal edition.

Supouse that exist two differentes users, admin, user1 and the reduction field is SalesMan. So user1 only acces to he's sells and the admin could acces to all sells. If i acces as user1, i only see the sells o user1, the problem is that when i reload the script, as user1, User1 can see all the sales.

Can anyone help me?

Thanks a lot

Re: Reduction Fields

ashfaq_haseeb — Wed, 28 May 2014 15:09:23 GMT

Hi,

Yo can remove reload access from user1.

Log-in with admin and go to document properties security tab and deselect all the privileges you want.

Make sure admin overwrite security is selected.

Regards

ASHFAQ

Re: Reduction Fields

Wed, 28 May 2014 15:18:37 GMT

Thanks for the answer, but the thing is that i want that user1 could reload the script

Re: Reduction Fields

ashfaq_haseeb — Wed, 28 May 2014 15:44:30 GMT

Hi,

I user reload document then it will have access to full data.

I don't think you can prevent this without removing reload option.

Regards

ASHFAQ

Re: Reduction Fields

hic — Wed, 28 May 2014 15:52:58 GMT

It doesn't help removing the reload option either... If the user has access to all data on the DB, then the user can just connect to the database and load all data. Either with a query tool or with another QlikView app.

To get any security, you must turn off database access for the user on the database.

HIC