Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to show average line with combo chart

Hi All,


I am new in Qlik Sense.


Anybody can explain how to show each 3 month average line with combo chart. As of know showing individual last 12 months data. I want to display also 3 month average line. Please advise how is it possible.


Thanks

Ankit Singh

8 Replies
OmarBenSalem

Can you put an image of the expected output?

What do you mean by each 3 months average?

Not applicable
Author

Hi Omar,

Average of 3 months will start from previous months for example:

last 3 months avg - jan2017, Dec2016 and Nov2016

another last 3 months avg - Oct2016, Sep2016 and Aug2016  and continue like same.


Please see the image for referenceImage.jpg

OmarBenSalem

stalwar1‌, I really didn't get Ankit point, can you assist please?

sunny_talwar

May be OP needs an Moving average?

Expression Scene Investigation, E1: Moving Average

Not applicable
Author

Hi Sunny,

I'm using Qlik Sense. What i've done and my requirements are below step wise step. Let me know if any other clarification is required.

1) Load 2 fields one is RequestDate and another is RequestID using stored procedure.

2) Drag and drop combo chart Add Dimension RequestDate with Expression formula of display month with year. Add Measure with Expression Count(RequestID). Combo chart display properly.

3) Now i want to add another Measure for average of 3 months (RequestID). How can i display average in combo chart means what expression i have to used for display average. Average will display like attached image.

for example

1) Jan 2017 block display - 3 Months Jan2017, Dec2016 & Nov2016

2) Dec 2016 block display - 3 Months Dec2016, Nov2016 & Oct2016

3) Nov 2016 block display - 3 Months Nov2016, Oct2016 & Sep2016


Thanks in advance


Regards,

Ankit SinghImage.jpg

sunny_talwar

Try this expression

RangeAvg(Above(Count(RequestID), 0, 3))

Not applicable
Author

Thanks Sunny It's working.

sunny_talwar

Great, please close the thread by marking correct response if you got what you wanted.

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny