topic Promoting/Demoting multiple expressions at once in QlikView

Promoting/Demoting multiple expressions at once

Thu, 18 Mar 2010 18:25:29 GMT

QV Community,

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]

Anyone know a workaround for this???

Regards,

James

Promoting/Demoting multiple expressions at once

Fri, 19 Mar 2010 14:06:27 GMT

I am guessing by the non-response that there is no way around around this. [:'(]

Promoting/Demoting multiple expressions at once

rothtd — Fri, 19 Mar 2010 14:48:43 GMT

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)"

Just a thought.