topic operating results from 2 different charts in QlikView

operating results from 2 different charts

thanhphongle — Fri, 12 Jun 2015 13:02:22 GMT

Hello Community,

is it possible to operate the end results from two different charts.

excample

1st chart

sum(Cost) = 600

2nd chart

avg(Taxes)=18,7%

Now i want to create a 3rd chart which only takes the endresults of both charts (600 and 18,7%)

-> (endresult of the 1st chart)*(endresult of the 2nd chart)=Newendresult

-> 600*18,7%=712.2

alexandros17 — Fri, 12 Jun 2015 13:27:48 GMT

In the script you can calculate the total sum and total % of both tables, put the results in 2 variables then multiply the variables.

You can reach the same result in layout (Eg TextBox) using a sum and aggr function

thanhphongle — Wed, 17 Jun 2015 08:45:31 GMT

unfortunetely i cant manage it in the script. may u have a solution for me how to manipulate the script?

thanhphongle — Wed, 17 Jun 2015 08:48:48 GMT

and can u exactly show me how to put the results in two variables ?