Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Not applicable

It is not possible.

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

Highlighted
Not applicable

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.

Highlighted
Not applicable

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

Highlighted
Not applicable

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

Thanks Giovanni

Highlighted
Not applicable

You're welcome!