Line chart help

Mon, 14 Mar 2011 22:40:42 GMT

I am trying to create a line chart to graph the change of the value of kpi_curr_val.

In my data set, I have multiple values for kpi_name. In my chart I created a calculated dimension to restrict the chart so that it will chart only one kpi value.

Calculated dimension:

=FieldValue(kpi_name,'Advances Outstanding')

I don't know if this is the right approach. In the expression tab, I added =kpi_curr_val as the expression. The objective is to simply chart the change over time for a specific kpi value.

The issue I'm seeing is that the values on my line chart (=kpi_curr_val) do not seem to be related to the dimension (=FieldValue(kpi_name,'Advances Outstanding').

Hopefully this makes sense. I need to ensure that there is a relationship between my calculated dimension and the =kpi_curr_val.

Thanks.

Line chart help

Mon, 14 Mar 2011 23:31:12 GMT

Hi,

I figure out a solution that seems to work.

My expression is

SUM({$<kpi_name={'Advances Outstanding'}>} kpi_curr_val)

topic Line chart help in QlikView

Line chart help

Line chart help