Previous one Month data

[NavinReddy]

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]

Take a look at this blog post:

QlikView App: Set Analysis - Prior Period Comparison

[NavinReddy]

Hi Bacius,

Thanks for your reply

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

Regards

Niranjan

[Kushal_Chawda]

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 · Accepted solution]

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]

Here is your Rolling 12.

Rolling12:

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