Qlik Community

Qlik Sense App Development

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

paulyeo11
Valued Contributor II

How to add a Average monthly sales line on to my existing monthly sales bar chart ?

Hi All

I have a Bar Chart in QS.

I like to add one more line to this bar chart , which show the average yearly sales. avg(sales)

Paul

3 Replies
paulyeo11
Valued Contributor II

Re: How to add a Average monthly sales line on to my existing monthly sales bar chart ?

my QVF

Re: How to add a Average monthly sales line on to my existing monthly sales bar chart ?

May be using a combo chart

Capture.PNG

paulyeo11
Valued Contributor II

Re: How to add a Average monthly sales line on to my existing monthly sales bar chart ?

Hi sunny

what i need is to have the average line on the chart .

For example if i select year = 2016 , total amount of sales 1,586 , Average = 1,541/6 = 256.

May i know how to do it ?

Paul

Community Browser