topic Re: Multi-line chart with an average line in QlikView

Multi-line chart with an average line

nagaiank — Sun, 05 Oct 2014 22:17:46 GMT

Hello friends,

I need to create a multiline chart with an average line for the following data.

If a state with n cities is selected, the chart should display monthly sales trend for each city in that state and an additional (n+1)th line showing the average monthly sales trend of the n cities. (For example, if IL is selected, the multiline chart will have five lines, one for each city and the fifth line showing the monthly average sales of the four cities.)

I have data in a table in four fields: state, city, month,sales.

What are the dimensions and expression(s) to be defined for the chart?. Appreciate any help in achieving this.

Re: Multi-line chart with an average line

Sun, 05 Oct 2014 23:00:05 GMT

Hi,

Check Marco Wedel's answer in this thread:

Add the average line to a line chart with multiple lines

Re: Multi-line chart with an average line

nagaiank — Sun, 05 Oct 2014 23:12:33 GMT

Thank you for your response.

I did go through Marco Wedel's post and would have used the solution, if I were to start with selection of cities. As I have to select state in my case and display lines for cities, the use of GetFieldSelections() is not an option.

Re: Multi-line chart with an average line

Sun, 05 Oct 2014 23:16:14 GMT

I see.

Can you try replacing the getfieldselections with this:

'$(=concat(distinct city, chr(39) & ', ' & chr(39)))'

Re: Multi-line chart with an average line

nagaiank — Sun, 05 Oct 2014 23:47:32 GMT

Thank you. It worked.