Thanks for quick reply Gysbert. A few updates...
I was able to create a bookmark that unchecks the "Always 1 selected" and basically selects all 3 options... and this was used as the Initial Selection like in your photo above. So that solved the issue with the report only showing 1 SCHOOL. This alone will make the current manual procedure i do more convenient for sure; however, the only issue I foresee is that it does not revert the qvw back to its original "Always 1 Selected" state for that field.
To give you background, when this report is fully automated, it will be triggered to create a new PDF every single time the app itself reloads (once an hour), and thus... i cant risk it reloading the 1st time and then saving back to the production folder with the "Always 1 Selected" turned off. Does this make sense? Any suggestions on a way to have the report turn this "Always 1 Selected" back on each time after it has successfully stored the PDF file in its folder?
And as for the "Clear All".. unfortunately that does not work with "Always 1 Selected". I tried that first just incase, but the reports function just like the dashboard does in general, where clear does not have any effect on a field that is "Always 1 selected".
Thanks though for quick responses!!
I have selected 'Matched Pair Name (Dept Name)' field for my reports to loop over but I also want them to iterate for different regions(North America, South America, Europe etc.)
Ex. Should iterate over 'Matched Pair Name (Dept Name)' for North America and then for South America and so on for all possible regions.
Is it possible?
If yes, How do I execute that? If not in qlikview can I use VBA script to make that happen?
Thanks in advance