topic sub total transfer in QlikView

sub total transfer

selcukcadir — Fri, 19 Feb 2016 08:47:29 GMT

Hi all,

chart 1 sub total (col 4) = 19

send to chart 2 b0 (col 4) value

Is it possible?

Re: sub total transfer

sunny_talwar — Fri, 19 Feb 2016 10:43:46 GMT

Try this expression:

If(col3 = 'main total value (a)', sum(TOTAL {<col1 = {'a*'}>} col4), sum(col4))

Re: sub total transfer

selcukcadir — Fri, 19 Feb 2016 11:48:21 GMT

Thanks, but,

My case, column no, I need to use,

If(col3 = 'main total value (a)', sum(TOTAL {<col1 = {'a*'}>} C2), sum(col4))

C2 column name

Re: sub total transfer

sunny_talwar — Fri, 19 Feb 2016 12:27:58 GMT

I am confused now. TOTAL for C2 is 18 and not 19?

Re: sub total transfer

jonathandienst — Fri, 19 Feb 2016 12:31:42 GMT

If i understand correctly, you would like to read the total of one chart object into another chart object. Unfortunately, that is not possible. You will have to recalculate that total again in the second chart.

Re: sub total transfer

selcukcadir — Fri, 19 Feb 2016 12:35:11 GMT

correct, C2 18 and C3 19

If(col3 = 'main total value (a)', sum(TOTAL {<col1 = {'a*'}>} C4), sum(col4))

column name sum failed

my add example file

Re: sub total transfer

sunny_talwar — Fri, 19 Feb 2016 13:02:24 GMT

Like jonathan pointed out you won't be able to use expression labels for getting totals. What is the number you want for main total value (a) (18 or 19)? and where does it come from (another table or same table)?