Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

tmumaw
Valued Contributor

5 Year Average

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

3 Replies
vvira1316
Valued Contributor II

Re: 5 Year Average

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
tmumaw
Valued Contributor

Re: 5 Year Average

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.

Partner
Partner

Re: 5 Year Average

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