topic Re: Usage of Chart Table data as the data source for another Sheet in same Report in QlikView

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

madhur4qlik — Wed, 13 Sep 2017 21:14:01 GMT

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

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

Anil_Babu_Samineni — Thu, 14 Sep 2017 02:48:03 GMT

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

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

rwunderlich — Thu, 14 Sep 2017 03:12:08 GMT

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