Qlik Community

Ask a Question

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
Showing results for 
Search instead for 
Did you mean: 

Problem: Permission on Loop And Reduce


I want to distribute a qvw document and give the receipients permissions. That works fine using "Loop field in document".

Now I have to add two administrator accounts. They should have permissions as well as the "Loop field in document" receipients.

I tried a lot but it ain´t working.

- Entered the admin accounts on "System / QlikView servers / Distribution": No effect.

- Entered the admin accounts on "Task / Distribute / Manually" As well as using "Loop field in document" worked - but now the publisher produces copies in the source directory and these copies are missing the admin permissions... only the "Loop field in document" worked here.

Any ideas?

Thanks in advance!


2 Replies

what version are you running? are you using dms or ntfs? are the admin accounts "built-in" accounts (e.g., power users or administrator)?


Creator III
Creator III


In Task Definition -> Distribute -> Loop Field in Document:

- Field containing recipient information: Login ID
- Check user identity on: SAM Account Name

Table in QVW report must be set up as such:

QVUser, [Login ID]
user1, user1
user1, user2
user1, Administrator
user2, user2
user2, Administrator
user3, <anyotherlogin>

Now if you loop and reduce by field QVUser,

- report copy of user1 is visible to user1, user2, Administrator
- report copy of user2 is visible to user1, Administrator
- report copy of user3 is visible to <anyotherlogin> windows login

Best - Marcel