5 Replies Latest reply: Dec 12, 2013 5:37 AM by Martin Palm RSS

    Link to column in another table



      I have two tables in one of my qlikview sheets, lets call them table 1 og 2.


      In table 1, I have a column, lets call that for column A.


      Column A is calculated upon the entire data load, and there for table 1 includes approx. 500.000 linies, and column A calculates a value for each of these linies. And I have added "total of rows" for column A.


      Table 2, is ussed for management reports, and should there for show only the total sum column A in table 1.


      Does anyone of you know how to make a formula, that on paper has the following function;


      = sum(columnA in table 1)??


      Thanks in advance


      Martin Palm