topic Re: Moving Sales in QlikView

Moving Sales

Sun, 27 Jan 2013 01:30:33 GMT

I've a requirement to display moving sales for monthwise where the sales should between current month and 12 month from current month .

that is value for 201112 = sum of 201001 to 201112 ,

201201 = sum of 201002 to 201201....

sales for month

Requirement:

Please help me on this.

Thanks

Sun, 27 Jan 2013 03:30:46 GMT

Hi.

Try this model. Maybe can help you.

Maybe someone create a better way.

Alessandro Furtado

Sun, 27 Jan 2013 04:19:14 GMT

Thanks Furtado.

I need this to be implemented in set analysis . I can't change the script.

Thanks.

Mon, 04 Feb 2013 20:30:11 GMT

Any clues on this ? I need your help

Thanks.

shree909 — Mon, 04 Feb 2013 21:30:55 GMT

Hi Try this..

for the actual Month

sum(if(Period=Dt_Period, Qtd))--> set analysis sum({<period={'Dt_Period'}>}qtd)

Last 12 monts...sum(if(Period>= Dt_Period2 and Period<= Dt_Period, Qtd))

set analyis sum({<period={'>=Dt_Period2, <=Dt_Period,'} >}qtd)