retrive total year sales

micheledenardi — Fri, 03 Jul 2015 10:46:00 GMT

Hi,

in my report i have lots of records that represent any sales of many years.

how can i sum equal product,year and months record and compare it with the sales of current year of the same product/months and obtain a % with the difference between the values ?

es.

product1: sales of first 4 months of 2014: 10€

product1: sales of first 4 months of 2015: 15€

result: +50% of last year sales for product1

thank's

Re: retrive total year sales

MK_QSL — Fri, 03 Jul 2015 10:52:33 GMT

2015 First 4 MONTHS

SUM({<Year=, Month= , Quarter=, Date = {">=$(=YearStart(Today()))<=$(=AddMonths(YearStart(Today()),3))"}>}Sales)

2014 First 4 MONTHS

SUM({<Year=, Month= , Quarter=, Date = {">=$(=YearStart(Today(),-1))<=$(=AddMonths(YearStart(Today(),-1),3))"}>}Sales)

Result

Num((Column(1)-Column(2))/Column(2),'#0.00%')

topic Re: retrive total year sales in QlikView

retrive total year sales

Re: retrive total year sales