I wonder: Yesterday I was working with a colleague on an 8_line_formula made up of I_don't_know_how_many nested IF_clauses.
That makes for a tremendously complicated formula, very error-prone, and a large number of brackets - so it's very easy to misplace one and the QlikView_script_editor does not keep up and just matches the nr. of opening and closing brackets.
In other instances, I have successfully replaced nested IFs with the above_mentioned PICK(MATCH()) function, that is so much more orderly for you have exactly one opening and one closing bracket per line, not ten closing brackets at the very end and such ...
The difference is, in those nested IF-constructs there are n:1 matches - several values are matched to one.
With directly in action I meant you could use an expression within the action which activate the sheets but I don't believe that it will work ....
An alternatively could be to use none action and triggers and used only visibility-conditions in all objects - this meant all objects are on one sheet and are one above the other and only the conditions over hours and minutes controls the visibility.
