I have a question concerning objects layout. Is it possible to script it?
Briefly my problem is the following. There are few obgects (for example, 6 diagrammes) in my QV document. For each one there is a button function of which is showing these objects. To make diagramme visible you need to click on an appropriate button. And I want these objects to be sorted depending on chosen buttons.
I really hope that my problem is more or less clear.
That is not exactly sorting. I've made an example. In this document every button relates to a certain graph. I need the following
On the first sheet you can choose (click on) as much objects (buttons) as you want. Then you click on 'Show' and go to the next sheet where these objects are represented. But, viewer can click on, for example, Q3 and Q4 (ignoring Q1 and Q2). In this case respective graphs will be located lower than I need. But they should replace Q1 and Q2 if latest weren't chosen.
That is only example. By sorting I meant arranging of only chosen objects from the top of the page.
Q1-Q4 are not quarters, these are indicators which do not share the same expression. In attached doc there is dummy data used just for visualization my problem. In a project there are much more indicators and expressions are more complicated.
Anyway, this nested IF-expression isn't working properly: when you choose, Q2 and Q3, for example, in result avg(Q2) is shown in both charts. How could it be improved?