topic Re: month on moth sales calculation in QlikView

month on moth sales calculation

nareshthavidishetty — Fri, 22 May 2015 12:08:39 GMT

hi im new to qlikview

im struck with following expression

month on month sales,year on year sales comparison

Qrishna — Fri, 22 May 2015 15:26:07 GMT

Hi Naresh,

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

Thanks

maxgro — Sat, 23 May 2015 19:13:50 GMT

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 — Sun, 24 May 2015 06:06:43 GMT

thanks