topic Re: 5 Year Average in QlikView

5 Year Average

tmumaw — Fri, 18 Jan 2019 16:12:57 GMT

Hi All,

I'm trying to create a 5 year average customer count report, however having a small issue trying to calculate the average. Here is a sample of what my pivot table looks like. Each of the years uses the following calculation Count(distinct([Sold To])) . The same sold to can be in multiple years that's why I can't do a straight count divided by 5. Here is what the pivot table looks like:

PC 2014 2015 2016 2017 2018

A 50 45 40 40 25

I need column at the end with total and average for the 5 years.

Thanks

Re: 5 Year Average

vvira1316 — Fri, 18 Jan 2019 16:33:43 GMT

Having only above information will not help to help you. Can you please share your application if you can or at least share more detail mocked data

Re: 5 Year Average

tmumaw — Fri, 18 Jan 2019 16:38:25 GMT

Model is too large to share. All I am trying to do is sum the columns across and create an average for the 5 years.

Re: 5 Year Average

dplr-rn — Fri, 18 Jan 2019 17:02:54 GMT

May need to use a valuelist for each of the years rather than a simple dimension. And use it along with before function

https://community.qlik.com/t5/QlikView-Documents/Missing-Manual-Before-and-After/ta-p/1488064