topic Re: Month on Month comparison over 12 months in QlikView

Month on Month comparison over 12 months

Tue, 16 Jun 2015 14:43:26 GMT

Hi, I hope you guys can I've read quite a few posts that are similar to this one, but can't seem to get anything to work for me.

I'm looking to analyse sales data from a month and compare it to the previous months figures and show what the difference is.

I can easily show the month and the sales results from it as in columns 1 & 2, but I wanted to create the data in columns 3 & 4.

Column 3 shows the data from column 2 in the previous month and column 4 is column 2 minus column 3

The dimension is UNIT.SOLD_MONTH and column 2 expression is sum(UNIT.TOTALSOLD)

Any ideas greatly welcomed, thanks Simon.

Sold Month	Month Units	Previous Month Units	Variance
May-15	148	173	-25
Apr-15	173	103	70
Mar-15	103	97	6
Feb-15	97	107	-10
Jan-15	107	82	25
Dec-14	82	203	-121
Nov-14	203	185	18
Oct-14	185	163	22
Sep-14	163	117	46
Aug-14	117	224	-107
Jul-14	224	169	55
Jun-14	169	0	169

Re: Month on Month comparison over 12 months

martinpohl — Tue, 16 Jun 2015 14:52:53 GMT

see attached

Regards

or use

RangeSum([Month Units],-[Previous Month Units]) as Variance

Re: Month on Month comparison over 12 months

giakoum — Tue, 16 Jun 2015 14:56:17 GMT

Calculating rolling n-period totals, averages or other aggregations

Re: Month on Month comparison over 12 months

Tue, 16 Jun 2015 14:56:26 GMT

Hi Martin, thanks for your reply, however I need this to be dynamic, so if I select a different buyer I get results that are relevant to them. Thanks

Re: Month on Month comparison over 12 months

Tue, 16 Jun 2015 15:18:26 GMT

Hi, thanks for this, I was able to use rangesum to create a 2 month total then take the month units from the rangesum total to give me the desired result

Re: Month on Month comparison over 12 months

Tue, 16 Jun 2015 15:19:44 GMT

rangesum(Below(sum(UNIT.TOTALSOLD),0,2))