Qlik Community

Qlik Community Help Discussions

Discussion board for questions on how to use Qlik Community and its features.

Not applicable

Visualizing values from various charts in one sheet object

Hi Guys,

can somebody help me, please.

In my management cockpit I want to show relevant results (values) from 8 different charts in one sheet object as an overview.

Maybe the following example can help you to understand my intention:

A first linechart shows the development of the KPI "ROI" from 2005 till 2012

A second linechart shows the development of the KPI "ROCE" from 2005 till 2012

A third ...

Now, what I want is to show the current value of "ROI" (current value = 55,47%) and "ROCE" (current value = 51,11%) from 2012 in one sheet object together. In addition it has to flexible no static string visualisation of the current values. That has to meant that a change to the values of the charts has to implised changes to the values of the sheet objects, too.

Is that possible? How can I do it?

Thanks in advance.

Greetings,

laju1014

1 Reply
jason_michaelid
Honored Contributor II

Visualizing values from various charts in one sheet object

You could use Aggr() and FirstSortedValue() in a text object for this, I think.

Let's say your chart 1 had Date as the dimension and Sum(ROI) as the expression.  You first textbox could have:

=FirstSortedValue(Aggr(Sum(ROI),Date),-Date)

Hope this helps,

Jason