topic 3 Months average in Bar Line Chart in QlikView

3 Months average in Bar Line Chart

rolandg1881 — Wed, 07 Jul 2021 12:01:55 GMT

Hi!

I have the following formular to see claims in a Line:

{< RMA_ClaimType = {'accepted claim'}, Customer_Number = {'70407'}, [Product] = {'L1'},[RMA_Typ]={'claim'},[Stock]-={'RMA Stock'} >}
DISTINCT[InvoicePos_RMA_Ammount]),RMA_Id))

and the Dimension monthyear, so i can see for example the course from Jan19 to Dec19

what i need is to to see a average line of the last three monts based on the formula

is this possible?

Thanks for help!!!

Greetings

Re: 3 Months average in Bar Line Chart

rubenmarin — Wed, 07 Jul 2021 12:44:14 GMT

Hi, one possible solution is to create an as-of calendar so each month can access data of other months https://community.qlik.com/t5/Qlik-Design-Blog/The-As-Of-Table/ba-p/1466130

Using this the expression for each month could be: Sum({$<MonthDiff={"<3"}>} Sales)/3

Another possible solution could be creating a new table(fields in data model to store the accumulated value of the last 3 months for customer/product... this could take more work.