month on moth sales calculation

[nareshthavidishetty]

hi im new to qlikview

im struck with following expression

month on month sales,year on year sales comparison

[Qrishna]

Hi Naresh,

could you please be more specific as what exactly your scenario is? and what exactly you are looking for.

Thanks

[maxgro · Accepted solution]

you can start adding some useful fields (ie in a master calendar) to your doc

     d,                                                         // date

     year(d) as y,                                         // year

     year(d)*12 + month(d) as mserial            // month serial

then with set analysis (v = sales)

sum({$ <y={$(=max(y))}>} v)                              // sales max year

sum({$ <y={$(=max(y)-1)}>} v)                           // previous

sum({$ <mserial={$(=max(mserial))}>} v)            // sales max month

sum({$ <mserial={$(=max(mserial)-1)}>} v)         // previous

or you can post your qlik doc (.qvw) here

[nareshthavidishetty]

thanks