topic Re: Help with MoM figure in QlikView

Help with MoM figure

tom906123 — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I am trying to create a table and a separate line graph to highlight MoM growth rates.

I have the below data:

OrderDate | Month# | Client | Sales

2018-03-16 3 abc123 $1,000

2018-03-18 3 xyz123 $1,500

2018-04-10 4 abc123 $2,000

2018-05-13 5 xyz123 $3,000

Total sales for March = $2,500

Total sales for April = $2,000

Total sales for May = $3,000

I would expect the first value to be null seeing as no data exists for February.

Any help would be much appreciated!

Nicole-Smith — Mon, 01 Oct 2018 17:30:33 GMT

Dimension:

=MonthName(MonthStart(OrderDate))

Expression:

(sum(Sales) - above(sum(Sales)))/above(sum(Sales))

Result:

tom906123 — Tue, 02 Oct 2018 14:13:01 GMT

Thanks very much - worked perfectly!