Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Can you put an image of the expected output?
What do you mean by each 3 months average?
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 reference
stalwar1, I really didn't get Ankit point, can you assist please?
May be OP needs an Moving average?
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 Singh
Try this expression
RangeAvg(Above(Count(RequestID), 0, 3))
Thanks Sunny It's working.
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