topic Re: Calculate last 3 months values in QlikView

Calculate last 3 months values

Thu, 15 Jan 2015 04:27:01 GMT

Dear all

How to Calculate value of last 3 months values.

For example on this January 2015, it will calculate December, November, October 2014 value.

Regards

Sofyan B

Re: Calculate last 3 months values

its_anandrjs — Thu, 15 Jan 2015 04:36:07 GMT

Hi,

In any chart try this expression

=Sum({<Date = {'>$(=Max((Addmonths(Date,-3)))) <$(=Max (Addmonths(Date,-1)))'}>} Sales)

=Sum({<DateField = {'>$(=Max((Addmonths(DateField,-3)))) <$(=Max(Addmonths(MonthEnd(DateField),-1)))'}>} Sales)

Regards

Anand

Re: Calculate last 3 months values

Thu, 15 Jan 2015 05:02:48 GMT

Hi Anand

Thanks for your respond

I don't have date column on data there's only year and month column.

Regards

Sofyan B

Re: Calculate last 3 months values

its_anandrjs — Thu, 15 Jan 2015 05:53:00 GMT

Hi,

In which format your Month and Year fields have better to add Monthyear field in load script or NUM month field.

Regards

Anand

Re: Calculate last 3 months values

ecolomer — Thu, 15 Jan 2015 06:13:12 GMT

here you have an example

Re: Calculate last 3 months values

senpradip007 — Thu, 15 Jan 2015 06:27:58 GMT

Please have a look on this. Hope it will help.

Re: Calculate last 3 months values

Thu, 15 Jan 2015 09:37:47 GMT

Hi Anand

I wrote this expressions

=Sum({<TransDate= {'>$(=Max((Addmonths(Today(),-3)))) <$(=Max(Addmonths(MonthEnd(Today()),-1)))'}>} Sales_Nett)

it returns 0

Any Suggestion

Regards

Sofyan B

Re: Calculate last 3 months values

its_anandrjs — Thu, 15 Jan 2015 11:12:29 GMT

Hi,

Your expression is correct and it gives output also some little change use Monthstart with addmonths also

=Sum({<TransDate= {'>=$(=Max(Monthstart(AddMonths(Today(),-3))) ) <$(=Max(Addmonths(MonthEnd(Today()),-1)))'}>} Sales_Nett)

Regards,

Anand