4 Replies Latest reply: Apr 7, 2015 8:43 AM by Abhishek Sen

# How to see Revenue one year back in Expression?

Hi, QlikView community

I have one issue I wanted to solve

Here below I have the data. Just a plain sales data.

I am doing an analysis for the SalesRep in my company.

They want to know what their how much they are selling e.g. Sum (Revenue), YTD.

But I got one request that I do not know how to solve.

They want to know what their Sum(Revenue) is from this day a year ago until today (one year back)

So I explain this request better. The SalesRep want to know when they open qlikview e.g. on the date 10. april 2015 they can see the Sum(Revenue) from 10. april 2014 until 10. april 2015.

Any have any ideas?

 OrderDate SalesRep Item Units Unit Cost Revenue 1.6.2014 Jones Pencil 95 1,99 189,05 1.23.2014 Kivell Binder 50 19,99 999,5 2.9.2014 Jardine Pencil 36 4,99 179,64 2.26.2014 Gill Pen 27 19,99 539,73 3.15.2014 Sorvino Pencil 56 2,99 167,44 4.1.2014 Jones Binder 60 4,99 299,4 4.18.2014 Andrews Pencil 75 1,99 149,25 5.5.2014 Jardine Pencil 90 4,99 449,1 5.22.2014 Thompson Pencil 32 1,99 63,68 6.8.2014 Jones Binder 60 8,99 539,4
• ###### Re: How to see Revenue one year back in Expression?

Check out the attached file.

Just change the no. format in the attached file for last year sales

UG

• ###### Re: How to see Revenue one year back in Expression?

Hi!

You can use this like expression.

Meanwhile, I see data format in qv settings (D.M.YYYY) is different from data (M.DD.YYYY).

So you have to solve this problem too.

• ###### Re: How to see Revenue one year back in Expression?

Hi,

You can try with the age function and sum with filter selection order_age=0

Krgrds

• ###### Re: How to see Revenue one year back in Expression?

You can try the attached solution.

Thanks!