Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

salto
Valued Contributor II

Division in total row in a chart

Hello,

I am showing three columns in a chart: Estimated and Real (in minutes), and the third one is Throughtput: Estimated / Real (in %)

When I go to the totals in the chart, the first two columns are totalized correctly (it is the SUM of all rows), but not the third one (it shows the average of the Throughtput column), but not the division between TotalEstimated and TotalReal, which is the value I am looking for.

How can I get the TotalEstimated /TotalReal value in the totals row of the chart?

Many thanks in advance.

Tags (2)
4 Replies
Not applicable

Re: Division in total row in a chart

Hi,

what is your expression for the throughput.

is it sum(Estimated)/sum(Real) ?

regards

Apurva

salto
Valued Contributor II

Re: Division in total row in a chart

Yes, it is exactly that way.

I have just added a chart with that exact formula and works fine, calculating the correct value. So the problem is more or less solved now.

But, is it possible to show that value in the totals row?

Regards,

srikanthsri1
Valued Contributor

Re: Division in total row in a chart

for a straight table ,in expression tab  go to total mode select the expression

and there u can define the totals should be a sum or avg

salto
Valued Contributor II

Re: Division in total row in a chart

Yes, I thought it was correct that way, but the average of the Throughputs is not equal to the Average Throughput:

Estimated     Real     Throughtput

2                    4          2/4 = 50%

3                    2          3/3 = 66%

5                    6          5/6=83,3%, correct value - but unable to get it in the totals row)

(which is different from (50%+66%)/2 = 58%, this is the average obtained in the totals row)

Anyway I have it in another chart, calculated apart. Thanks.

Community Browser