topic Re: Sum from another chart in QlikView

Sum from another chart

Wed, 25 Nov 2020 16:16:04 GMT

I haev two charts with each having a sum() of their table.

But i'd like to in the same table show totals on the last row as one table.sum + table2.sum and then a total of these 2

table1

Sum: 1234

table2:

sum 2345

Table 3:

1234

2345

Total: 3579

Re: Sum from another chart

sunny_talwar — Tue, 04 Oct 2016 13:43:32 GMT

May be use Dimensionality() function to get this done

If(Dimensionality() = 0, Sum(Table1.Sum) + Sum(Table2.Sum), YourExpression)

Re: Sum from another chart

marcus_sommer — Tue, 04 Oct 2016 13:44:37 GMT

You couldn't access anything from another object - you will need to build everything within one object.

- Marcus

Re: Sum from another chart

giakoum — Tue, 04 Oct 2016 13:53:20 GMT

And use variables to hold expressions so that you only correct them once if a change is needed

Re: Sum from another chart

Wed, 05 Oct 2016 12:17:17 GMT

Thanks making 2 variables worked. But what would be optimal and I want to achieve is not the sum per row for 10 rows I just want a new row below the totals I already have and there another row with the sum of these 2 fields. Is that possible?

Re: Sum from another chart

Wed, 05 Oct 2016 12:27:23 GMT

If you look at this one; I have 2 tables. And then I did as you said 2 variables summed them. 1+2 = 3. Problem is as you see I get multiple rows of column 3. I don't want them there I just want the totals of 1+2 preferably on the last row or even mroe prefered 3 totals rows so to speak with those values.

Am I confusing?

Re: Sum from another chart

marcus_sommer — Wed, 05 Oct 2016 12:35:34 GMT

Take a look on the suggestion from Sunny and add those totals to a certain (maybe additionally) dimensionality - whereby you might need some aggr, TOTAL or set analysis to calculate these totals independent from the dimensions from the current object. Further it could be helpful to transfer these calculations into a variable to minimize the complexity and to improve the performance.

- Marcus