topic Re: Month on Month analysis in QlikView

Month on Month analysis

srinivasa1 — Sat, 23 Feb 2013 03:07:13 GMT

Can any guide me how i can do Month on Month analysis

I would like to do calculation for sales diffrence Year 2011,2012,2013 ie :if selected FMonth filter Jan,Feb,Mar

My sales difference will be like (2012_jan - 2011_Jan ) and 2013_Jan-2012_Jan Have attached qvw

Highly appreciating any help

Re: Month on Month analysis

phaneendra_kunc — Sat, 23 Feb 2013 04:10:53 GMT

Use following...

Dimensions: Product, Fmonth

Expressions:

=sum({<FYear={'$(=Max(FYear))'}>}Sales) - sum({<FYear={'$(=Max(FYear) - 1)'}>}Sales) // For 2013-2012

=sum({<FYear={'$(=Max(FYear)-1)'}>}Sales) - sum({<FYear={'$(=Max(FYear) - 2)'}>}Sales) // For 2012 - 2011

See attached...

Re: Month on Month analysis

srinivasa1 — Sat, 23 Feb 2013 05:26:54 GMT

Thanks It helped me lot

Thanks

Re: Month on Month analysis

srinivasa1 — Sat, 23 Feb 2013 05:53:55 GMT

Some issue i found in that .if start selection from Jan to Mar then mar 2013--2012 clos also displaying and if selecting from feb onwoards my year will become 2011-2010 data. there is no data for 2010.still its displayinf it should be 2012-2011 only.can you pls guide on same

Re: Month on Month analysis

phaneendra_kunc — Sat, 23 Feb 2013 06:02:04 GMT

See attached..