Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
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
jonathandienst
Partner - Champion III
Partner - Champion III

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