Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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
Esteemed Contributor

Re: How to show average line with combo chart

Can you put an image of the expected output?

What do you mean by each 3 months average?

Not applicable

Re: How to show average line with combo chart

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
Esteemed Contributor

Re: How to show average line with combo chart

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

Re: How to show average line with combo chart

May be OP needs an Moving average?

Expression Scene Investigation, E1: Moving Average

Not applicable

Re: How to show average line with combo chart

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

Re: How to show average line with combo chart

Try this expression

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

Not applicable

Re: How to show average line with combo chart

Thanks Sunny It's working.

Re: How to show average line with combo chart

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

Community Browser