Usage of Chart Table data as the data source for another Sheet in same Report

[madhur4qlik]

Hi All,

I have quite a peculiar requirement here not sure how to ahead with.

We developed some complex logic to show data dynamically in a pivot and straight table respectively.

Now question is can we use the end result of those tables as the data source to objects in another sheet of same report . for example.

I have 6 columns of which M1, M2 and Dim3 are calculated ones on some selection.

Table 1:

Dim1	Dim2	M1	M2	Dim3	M3
x	x	x	x	x	x
x	x	x	x	x	x
x	x	x	x	x	x
x	x	x	x	x	x
x	x	x	x	x	x

Now I want above result set to be used with column names and their values to used in another chart in a different sheet in same report but with no further calculation of M1, M2 and Dim3 their result sets should be lo

[Anil_Babu_Samineni]

If you already data model setup then yes, many sheets we can use the same fields either dims or measures.. Can you explain little more to check

[rwunderlich]

You cannot re-use expression results from one chart in another chart.  What you can do is recalculate the expression in the other chart, using aggr() to specify the dimensions as required.

For example,

=max(aggr(your M1 expression, Dim1, Dim2, Dim3))

would return the max value of M1 from your sample chart.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com