Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Highlighted
jerryr125
New Contributor III

Line Chart - Add Mean and Upper/Lower Control Limits

Hi - I have a line chart :

Dimension : Date

Measure : sum(Amount)

I would like to add the mean and potentially the upper/lower control limits.

Any thoughts/examples ? Jerry

1 Solution

Accepted Solutions
jerryr125
New Contributor III

Re: Line Chart - Add Mean and Upper/Lower Control Limits

Hi - I added formula reference lines -worked!

3 Replies
jerryr125
New Contributor III

Re: Line Chart - Add Mean and Upper/Lower Control Limits

Any thoughts on this question? 

What if I try this :

Of the values selected, what if I wish to display the mean (average) line?

So for example, the user selects a date range and a category - for that selection criteria it displays an average line on the line chart .

 

Thoughts ? jerry

 

Partner
Partner

Re: Line Chart - Add Mean and Upper/Lower Control Limits

Hi Jerry,

Use the following formulas:

Mean: Avg(Amount)

Lower: Min(Amount)

Upper: Max(Amount)

Jordy

Climber

Work smarter, not harder
jerryr125
New Contributor III

Re: Line Chart - Add Mean and Upper/Lower Control Limits

Hi - I added formula reference lines -worked!