Please tell me there is a way in Qlikview 9 to select multiple expressions at once and either promote or demote them in a chart. I currently have an app that has a couple hundred expressions and I need to move a bunch of them around, add empty spaces, etc etc... and the only way i see to do it is select each one INDIVUALLY and click Demote 300 times until its at the bottom, and then select the 2nd one, click demote 300 times, etc etc etc... I might die [:S]
I haven't tried this yet, but I wonder if you can start with a chart with no expressions. Write a macro to add each expression one by one, or read a spreadsheet to get the list of expressions. If expressions are ordered sequentially by their 'load' order, then you can order them in your spreadsheet/macro, and let the macro add them for you.
Looking at the API guide it looks like the following code might be useful:
Set Graph = ActiveDocument.Sheets("Main").CreateLineChart Graph.AddExpression "sum(Amount)"
