Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Show the Max/Min values in an Average Line Chart

Hello,

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

Screen.png

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!

6 Replies
scully01
Contributor II
Contributor II

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.


satyadev_j
Specialist
Specialist

Hi,

You may try something like below,

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

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

MarcoWedel

Hi,

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

QlikCommunity_Thread_135264_Pic1.JPG.jpg

QlikCommunity_Thread_135264_Pic2.JPG.jpg

hope this helps

regards

Marco

antoniotiman
Master III
Master III

Hi,

see attachment, the values are shown in axis x.

Regards

Not applicable
Author

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.

Chart.png

MarcoWedel

Hi,

like this?

QlikCommunity_Thread_135264_Pic3.JPG.jpg

hope this helps

regards

Marco