topic Re: Last 13 months data in QlikView

Last 13 months data

Mon, 30 Jun 2014 14:41:30 GMT

Hi Guys,

I have data of 20 period as 2013P01 format.

I have only one field yearperiod,,based on this how could i apply last 10 months data. whatever data come i always want to keep last 10 mnths data in my report. Could you please help me

Re: Last 13 months data

Anonymous — Tue, 01 Jul 2014 02:36:32 GMT

Hi Kalyani,

You can use below script in where clause to achieve that. Here, I am converting yearperiod field which has "2013P01" format to "1/1/2013" date format.

Where Date(Date#(yearperiod, 'YYYYPMM'))>AddMonths(Today(), -10);

Hope it helps you

Satya

Re: Last 13 months data

Tue, 01 Jul 2014 17:24:19 GMT

Hi Satyadev..thanks a lot for your response.

But I have tried with the above expression but it is not working.

While loading yearperiod I an restricting with thus expression,but not working for me,

Re: Last 13 months data

MarcoARaymundo — Tue, 01 Jul 2014 17:48:11 GMT

Hi!

Try this. In your expression put:

Sum({<YEARPERIOD={">=$(=AddMonths(Today(), -10))<=$(=Date(Today(),'YYYYMM'))"}>} FIELD)

Re: Last 13 months data

Anonymous — Wed, 02 Jul 2014 01:17:51 GMT

Hi Kalyani,

Are you getting any error? Could you share a sample app to understand more on this.

The above script first converting yearperiod which is in "2013P01" format to date format and extracting last 10 months data by comparing with addmonths(today(), -10).

Re: Last 13 months data

jagan — Wed, 02 Jul 2014 02:07:12 GMT

Hi,

LOAD

MakeDate(Left(MonthFieldName, 4), Right(MonthFieldName, 2)) AS DateFieldName

FROM DataSource;

Now use this expression

=sum({<MonthFieldName=, YearFieldName=, DateFieldName={'>=$(=MonthStart(Max(DateFieldName), -10))<=$(=Date(Max(DateFieldName)))'}>} MeasureName)

=sum({<MonthFieldName=, YearFieldName=, DateFieldName={'>=$(=MonthStart(Max(DateFieldName), -9))<=$(=Date(Max(DateFieldName)))'}>} MeasureName)

Regards,

Jagan.

Re: Last 13 months data

Sat, 12 Jul 2014 06:57:34 GMT

hi guys thanx a lot,it works

Re: Last 13 months data

jagan — Mon, 14 Jul 2014 02:23:33 GMT

Hi Kalyani,

Please close this thread by giving Correct and Useful Answers to the posts which are helpful to you, so that it would be helpful for others.

Regards,

Jagan.