Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

srinivasa1
Contributor

Month on Month analysis

Hi  

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

Tags (1)
4 Replies
phaneendra_kunc
Valued Contributor III

Re: Month on Month analysis

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...

srinivasa1
Contributor

Re: Month on Month analysis

Thanks It helped me lot

Thanks

srinivasa1
Contributor

Re: Month on Month analysis

Hi

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

phaneendra_kunc
Valued Contributor III

Re: Month on Month analysis

See attached..

Community Browser