topic Loop and Distribute in QlikView

Loop and Distribute

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

Good morning everyone. We just upgraded to 9.0 SR4 and Iam trying to do a loop and distribute on one of our documents. On the reduce tab I have selected values 133131 and 135231. I am controling everything through Active Directory, so I have these groups setup 133131 and 135231 setup in AD. On my distribute tab I have selected from AD 133131 and 135231. What is happening is one document is getting published called 133131 and it also contains 135231. How can I create 2 separate documents.....Thanks

Thom

Loop and Distribute

fernandotoledo — Mon, 14 Jun 2010 15:31:50 GMT

I think Publisher generates one file for each USER. If this user can see two groups, then the file will keep them.

Why are you trying to split the files?

Loop and Distribute

tmumaw — Mon, 14 Jun 2010 15:39:41 GMT

The user can not see both groups. I am spliting the files because one user is only allowed to see 133131 and the other is only allowed to see 135231.

Loop and Distribute

fernandotoledo — Mon, 14 Jun 2010 15:52:37 GMT

Hi Thom,

Then you should create a file reduction in the QVW.

You can make it by creating an association between User and Group in the script´s "Section Access" statement. There you can load NTNAME + GROUP from AD.

Hope it helps!

Fernando

Loop and Distribute

tmumaw — Mon, 14 Jun 2010 15:58:18 GMT

I did not have to do this in 8.5. I should just be able to tell it to do a loop and distribute on a field and it will create individual documents based on the field (which it's not doing it's combinding all documents into one). I let AD control who sees what. I think there maybe a small bug in 9.0 SR 4.

Thanks
Thom

Loop and Distribute

Anonymous — Mon, 14 Jun 2010 16:12:52 GMT

Thom,

I have found this to be a problem with QV9.0 also. We use to be able to limit groups in the loop and reduce portion of publisher. I could only work around this by creating seperate reduction tasks. I know not the answer you wanted but I think this needs to be pushed back to QV as a issue in the new version.

Let us know if you find anyother solutions.

Loop and Distribute

tmumaw — Mon, 14 Jun 2010 16:18:12 GMT

Thanks JS. I have opened a case with Qlikview. I will keep everyone posted on what I find out.

Thom

Loop and Distribute

Tue, 15 Jun 2010 08:10:58 GMT

Thom,

I think you want to use the Loop and Reduce rather than selecting values in the Simple Reduce section. If you select the Field that contains the Groups in the Loop and Reduce dropdown Publisher will create a document for each group within that field with only that groups associations whereas selecting fields in the Simple Reduce section will create a document with data for the values selected hence getting data for both groups.

Tony

Loop and Distribute

Anonymous — Tue, 15 Jun 2010 13:07:32 GMT

Tony,

I believe he is using loop and reduce, but the choice to limit his loop and reduce to only certain values in the "reduction" field seems to have been eliminated in QV 9.0. It was a nice functionality that I am hoping we can get back.

Thom, Can you confirm that you are trying to loop and reduce only on certain values in a reduction field?

Loop and Distribute

tmumaw — Tue, 15 Jun 2010 13:22:49 GMT

JS you are correct. I had to change my loop and distribute from a simple to a complete loop and distribute. In the simple loop and distribute where I specified the profit centers I wanted to reduce on seems to no longer work in 9.0 SR4. I had to select loop and distribute on a field called profit center and now it's generating QVW's for every profit center in my model. Runs way too long considering all I want to do a loop and distribute on is 2 profit centers, not 150.

Thom

Loop and Distribute

Anonymous — Tue, 15 Jun 2010 13:41:45 GMT

Thom,

A couple of suggestions: You could create two seperate simple reductions and trigger one off the other, or you could add a new "reduction" field in your qvw that links only to the two values in which you want to reduce on. Either one might be better than producing 150 to get 2.

Here's hoping the QV adds this functionality back in.

Good luck!

Loop and Distribute

tmumaw — Tue, 15 Jun 2010 14:00:17 GMT

Thanks JS.....I really have about 75+ profit centers to do. Lets just hope QV adds the functionality back in soon.