Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
tmumaw
Specialist II
Specialist II

Loop and Distribute

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

11 Replies
fernandotoledo
Partner - Specialist
Partner - Specialist

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?

tmumaw
Specialist II
Specialist II
Author

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.

fernandotoledo
Partner - Specialist
Partner - Specialist

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

tmumaw
Specialist II
Specialist II
Author

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

Anonymous
Not applicable

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.

JS

tmumaw
Specialist II
Specialist II
Author

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

Thom

Not applicable

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

Anonymous
Not applicable

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?

JS

tmumaw
Specialist II
Specialist II
Author

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