Rolling Month

[#1]

hi all....

I am new in qlikview...

So, please tell me how can I create Rolling Month 12 ???? For Sales????

please sort out my problem.

thanks in advance...

[IAMDV]

Please can you provide an example? It is difficult to comprehend like this...

[tresB]

Try this: Your calculated dimension: =MonthName(Date) Expression: =Sum({1 =$(#vRollingStart) } Sales) Where variable vRollingStart=monthstart(addmonths(max(Date),-11)) vRollingEnd=monthend(max(Date)) Regards, tresesco

[Anonymous]

Hi.

Do u have months in your file?

[#5]

hi Oscarashi..

yes I have month in my file ....

thanks for reply.

Regards,

Shekhar Munjal