topic Re: Previous one Month data in QlikView

Previous one Month data

NavinReddy — Tue, 10 May 2016 07:09:54 GMT

Dear Experts

i am trying to implement the Previous one month and Rolling 3 Months data to display on textbox

i have tried but its giving some error please help me to get the Previous n Months data selection

for reference i have attached the sample application

Best Regards,

Niranjan

MindaugasBacius — Tue, 10 May 2016 07:22:01 GMT

Take a look at this blog post:

NavinReddy — Tue, 10 May 2016 07:41:35 GMT

Hi Bacius,

Thanks for your reply

i have tried with MTD expression i got the full year of data

Regards

Niranjan

Kushal_Chawda — Tue, 10 May 2016 07:49:49 GMT

if you have Date field then Try below

Previos 1 month

=sum({<Date = {">=$(=monthstart(addmonths(max(Date),-1)))<=$(=monthend(addmonths(max(Date),-1)))"}>}Value)

Rolling 3 months

=sum({<Date = {">=$(=addmonths(max(Date),-3))<=$(=max(Date))"}>}Value)

phaneendra_kunc — Tue, 10 May 2016 07:55:48 GMT

try these..

PrevMonth:

=Sum({<Period1={$(=num(addmonths(Max(Period1),-1)))}>}Market_Volume_Sales)

Rolling3:

=Sum({<Period1={'>=$(=num(addmonths(Max(Period1),-2)))<=$(=Max(Period1))'}>}Market_Volume_Sales)

phaneendra_kunc — Tue, 10 May 2016 21:00:05 GMT

Here is your Rolling 12.

Rolling12:

=Sum({<Period1={'>=$(=num(addmonths(Max(Period1),-11)))<=$(=Max(Period1))'}>}Market_Volume_Sales)