I'm getting the following error when Loop and Reduce task run:
Error: Could not run ReduceData. Exception=QVBWrapper.Exceptions.ReduceAndSaveFailedException: Failed to reduce and save document: C:\ProgramData\QlikTech\DistributionService\1\temp\1d115324-df2a-458c-a5d1-31c7e7749f1f\document.qvw ---> System.Runtime.InteropServices.COMException: Error HRESULT E_FAIL has been returned from a call to a COM component.
Please check the write permissions on the User documents folder for the ID which you are running the schedule Task? and apply write permissions to the folder and try again.
if it is still not working, I would suggest to create a qvw file with the data only for 2 distinct values(I mean filter out the possible data in script for 5 values) and try to loop and distribute for those 2 values. If it is working then in it is not issue with the data.
Now you create a task only for reload, then create tasks for distribution as suggested below.
There is a other way(may not be exact solutions), you can create a 7 tasks one after one with Simple loop for your 7 different values.