Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi im new to qlikview
im struck with following expression
month on month sales,year on year sales comparison
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
Hi Naresh,
could you please be more specific as what exactly your scenario is? and what exactly you are looking for.
Thanks
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
thanks