topic Re: Re: Show the Max/Min values in an Average Line Chart in QlikView

Show the Max/Min values in an Average Line Chart

Sat, 27 Sep 2014 22:58:22 GMT

Hello,

I have the following line chart for sales as an average - you can find the QVW file attached:

My expression for the line chart is AVG(Sales).

The dimension is a hierarchical group with year, month and date.

What I show in the line chart is an average for every year, month and date.

The thing is that I need to show the MAX and MIN values, that you can see on the right as text objects.

Do you know how could I do that?

Thank you!

Re: Show the Max/Min values in an Average Line Chart

Anonymous — Sun, 28 Sep 2014 07:37:52 GMT

add in another expression of =max(TOTAL Sales) if you want the maximum across the selected data or simply =max(Sales) if it is the maximum for each YMD.

Re: Show the Max/Min values in an Average Line Chart

Anonymous — Sun, 28 Sep 2014 09:10:47 GMT

Hi,

You may try something like below,

Max(Aggr(Sum(Sales), Year))

Min(Aggr(Sum(Sales), Year))

Re: Show the Max/Min values in an Average Line Chart

MarcoWedel — Sun, 28 Sep 2014 11:40:45 GMT

Hi,

just use the overal Min and Max expressions as reference lines:

hope this helps

regards

Marco

Re: Show the Max/Min values in an Average Line Chart

antoniotiman — Sun, 28 Sep 2014 12:53:00 GMT

Hi,

see attachment, the values are shown in axis x.

Regards

Re: Re: Show the Max/Min values in an Average Line Chart

Tue, 30 Sep 2014 03:07:28 GMT

Thanks Marco, I like your answer but is there any way to see the blue line (average) bigger in the center of the chart and the red lines (max and min) on the sides so that I could focus on the average line chart, which is the most important thing I want to show? Thank you.

Re: Re: Re: Show the Max/Min values in an Average Line Chart

MarcoWedel — Tue, 30 Sep 2014 10:16:13 GMT

Hi,

like this?

hope this helps

regards

Marco