Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

5 Replies
Not applicable
Author

It is not possible.

for better performance calculates the value of the column during the script

Not applicable
Author

I already use the script to calculate many of the needed steps.

Are you sure that this is not possible at all? It is possible in access, Excel an other datawarehouse systems.

Not applicable
Author

yes, i'm sure. if you want to use the same formula you have to copy it or ctrl+alt+v

If the formula contains sum avg etc. -> sum(aggr(sum.... and the performance is low

Not applicable
Author

I have now tried part of this, and it seems that this might be the way to do it.

Thanks Giovanni

Not applicable
Author

You're welcome!