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

    Link to column in another table

      Hi,

       

      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

      /Denmark