Trying to make it a 0 skill, one set of selections, single qlikview sheet process for the end user. That said, two items in the list of items have me thinking of alternate states and multi-state expressions now. End user will know the following:
Alternate states might be like
date range for activity 1 (listbox, alt state 1)
date range for activity 2 (listbox, alt state 2)
1-3 source values for activity 2 (listbox, alt state 2)
season value for activity 3 (listbox, alt state 3)
1-X values for activity 3 shortnames (listbox, alt state 3)
Clients have pretty much the same questions and report format (who did 1, who did 2, who did 3, who did only 1, who did only 2, who did 1 and 2, who did 1 and 2 and 3, who did X of 3, who did ALL of 3), but completely different values for all of the above..
The end users are smart people and don't necessarily need me to build for 0-skill, but there's a fair managerial/strategic demand for me to produce things my 7 year old could operate without risk of error. I have a lot of things down to where people click the client name, export from the correct table, and call it done, but this one is like combining... everything.
Supposing I'll go dig up papers for syntax to reference multiple states in single formulas, but feel free to throw me a line.