topic Re: Calculating index in a Line Chart in QlikView

Calculating index in a Line Chart

Wed, 09 Jan 2013 12:50:02 GMT

Hi all

I've run in to a problem calculating an index in line charts, where index 100 is the first year selected in my list box containing my variable "Year" (from 2005-2012).

I want the index chart to look somewhat like #2 and #3 underneath (#1 is the "normal" line chart), and the index should only be calulated in the selected years (#2 has all years selected, and #3 has 2007-2011 selected). The dots in the index line chart should be calculated like this: (First Year in selection/Year)*100. For example in #3 this means:

- value for Year "2007": (6333/6333)*100=100

- value for Year "2008": (6333/5482)*100=87

- value for Year "2009": (6333/6666)*100=105

... and so on.

Can anyone help me on this one?

Thanks in advance

Cheers

Bruno

For

Re: Calculating index in a Line Chart

swuehl — Wed, 09 Jan 2013 13:04:26 GMT

Look into the chart inter record functions, namely top(). top() will return your expression evaluated in the context of your first dimension value, so try something like

=top( count(Frequency) ) / count(Frequency) * 100

Replace count(Frequency) with the expression you are currently using.

Hope this helps,

Stefan

Re: Calculating index in a Line Chart

Wed, 09 Jan 2013 13:22:26 GMT

Hi Stefan

It worked perfectly

Thanks a lot for your help!

Cheers Bruno

Re: Calculating index in a Line Chart

Wed, 09 Jan 2013 14:41:54 GMT

Hi Stefan

It worked perfectly

Thanks a lot for your help!

Cheers Bruno