Is there a log that keep tracks of what values are processed? I have a report that works fine. It creates 715 PDF files. The problem is there should be 718. I have added an on-demand option (clone of the report with cycle unchecked) and when I select one of the missing values, the report is generated just fine. I am not sure why the file isn't being generated during the main execution.
Any thoughts on how to debug?
So just to be clear.
So just to be clear.
1. Frank suggestion regarding filters is right. Very important thing to remember is how Qlik Sense works and how associative engine works. Scenario which you have may be possible when you have a filter which excludes yours 3 values from your possible selection, however your charts can have set analysis to negate those filters. This can cause situation in which 3 of your values are not available in cycle (since they are excluded by selection) but are available in the chart as set analysis can be ignoring filters applied. I know - since you have tested it with OnDemand it should work anyway though!
2. When generating reports is it possible that you could have some sort of filter you were not aware of? like user filter or section access?
3. The other thing would be to check what are the characters used in the cycled field - if there are some charachters which are not allowed in filenames it can be a cause of those not generating. In that case I would try to autonumber this field in data load script (or create autonumbered copy of that field) and try to run cycle through that
I hope it makes sense.
When you create a cycle you have to include the cycled field in the output file name. You can place it as first so you can order generated fields by that field. Then you can do a dir *.xlsx > list.txt (I suppose you are generating Excel reports otherwise change the extension) to have the complete list of generated reports in a file, import the list.txt in Excel and compare it with the list of distinct values of the cycled field exported from Qlik. That should helps you in understanding which are the missing values.
You can also create a Qlik variable that contains the GetCurrentSelections() results and place it in the template or in the file name (pay attention to respect Windows file names rules in this case) to check if there are other filters applied.
I suppose that you are sure that the 3 missing values are available in the source app.