topic Using output of one chart in another in QlikView

Using output of one chart in another

Mon, 10 Jun 2013 11:42:56 GMT

I have a created a straight table which uses data plus undertakes some calculations on it. I.e. I get total of Premiums in one column then spread it over policy duration in another column and get Accrued Premium. Then take Payouts from another table and create an expression to display Profit. In the same chart I can refer to other expressions and get the result.

Now I want to create a bar graph using the output of column [Profit] which is in Chart ID CH28. How can I reference that chart?

Thanks.

Re: Using output of one chart in another

alexandros17 — Mon, 10 Jun 2013 11:49:35 GMT

I think you can't; each chart output depends on dimensions and expressions of that chart.

To obtain same values in another chart ypu have to replicate dimensions and expressions.

Hope it helps

Re: Using output of one chart in another

Tue, 11 Jun 2013 04:03:18 GMT

Since the working is done in quite a few steps, is it possible to have expressions and hide them? Otherwise it becomes quite a long expression.

Re: Using output of one chart in another

jonathandienst — Tue, 11 Jun 2013 07:22:36 GMT

I am afraid there is no way to read the results of an expression from a chart into another chart. What you can do, is put the expression into a variable and use that variable in both charts. For (a simple) example, In your script:

Set vExpr = =Sum(Sales);

(Yes that is two = signs) You could also enter the expression using the variable dialog (Ctrl-Alt-V). And in your charts, use the expression like this:

$(vExpr)

If the expression changes, then simply change the variable definition. Note that this does not stop QV from recalculating the expression for each chart.

Hope that helps

Jonathan