Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

how to bring a calculated field column total into next column ???

Dear All

how to bring a calculated field column total into next column ???

for example

Column 1Column 2Column 3
Total3,735.323,735.32
01/07/2012461.603,735.32
02/07/2012889.083,735.32
03/07/2012621.453,735.32
04/07/201212.763,735.32
05/07/2012623.033,735.32
06/07/2012673.713,735.32
07/07/2012350.213,735.32
08/07/2012103.493,735.32


column 2 is a calculated field the total value 3735.32

column 2 total should be come into column 3 as 3735.32, is it possible ???

1 Reply
MVP
MVP

Re: how to bring a calculated field column total into next column ???

Hi

No, it do not believe that it is possible to read the total value from one column. You can recalculate the total by using an Aggr expression:

=Sum(Aggr(...the expression for column1..., ...table dimension(s)...))

Just place the column 1 expression and dimensions in the expression as shown.

Hope that helps

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Community Browser