topic compare sales current vs previous in QlikView

compare sales current vs previous

geogou1973 — Fri, 25 Oct 2013 07:21:07 GMT

Hello.

How can i compare the current sales vs previous sales giving only the current year date in the selections and the chart giving me also the previous sale date in the same period and in the same weekday. Also if i give the month compare automatically the sales in the previous year. Is there any set analysis to do this ?

Below i have a sample.

Thank you in advance.

Re: compare sales current vs previous

Fri, 25 Oct 2013 08:37:56 GMT

Hi,

Have a look at attached QVW, and let me know you got what you want ?

Or let me what you want in detail.

Thanks,

Re: compare sales current vs previous

geogou1973 — Fri, 25 Oct 2013 09:10:30 GMT

It is very usefull but when i give 23/10/2013 current sales and the week day is WED i want to compare with the 24/10/2012 that is also WED.

How can i do this ?

Re: compare sales current vs previous

Fri, 25 Oct 2013 09:51:21 GMT

use this expression

sum({<YEAR={$(=only(YEAR)-1)},MONTH={$(=max(MONTH))},WEEK_DAY={"$(=only(WEEK_DAY))"},DATE= >}SALES)

Re: compare sales current vs previous

Fri, 25 Oct 2013 09:59:43 GMT

Hi hope it will help u

Re: compare sales current vs previous

Fri, 25 Oct 2013 11:21:50 GMT

Use this one...

Sum({$<DATE={">=$(=addmonths(Today(),-12)+1) <=$(=addmonths(Today(),-12)+1)"}>} SALES)