Last n period (trigger)

[nicogene]

Dear all,

I try to get the last 12 periods by clicking on the tab 2 (with implementation of an action) .qvw is attached
With max formula max (Period), it works with the last period.
but max (Period-12) doesn't work.

Thank you for your help

Best regards,

Nicolas Généré.

[Anonymous]

Nicolas

I have adjusted you qvw and re-attached it, does it give what you were after.

I changed the field in your List Box to an <Expression>

     =  if ( aggr ( rank ( only ( Period) ) , Period ) <= 12 , Period , null() )

Best Regards,     Bill

[Clever_Anjos]

Try this

='<=' & date(AddMonths(max(Period),-12),'MM/YYYY')

[MayilVahanan]

Hi

Try like this

In action  instead of using =(max(Period)-12) , because its gives number, but we need to convert into date. For last 12 periods, i think you need last 12 months , for tat use like following.

=Date(AddYears(max(Period),-1))

[tresB]

May be like attached sample.

[qlikpahadi07]

Hi Nicolas,

You need to write

=Date(max(Period)-365) as numbers will be taken as days not Months else you can use Set Analysis By selecting Previous Year

=max( {<Year = {$(=Max(Year)-1)} >} Period)

See the attachment

[rajni_batra]

Hello Nicolas,

please find the attched file. Hope this helps u..

Regards,

Rajni

[struniger]

Try using this expression: addmonths(max(Period),-12)

[jonathandienst]

Hi

Try Max(Period) - 12

Regards

Jonathan

[v_iyyappan]

Hi,

Try like this

Load

     *,

     MakeDate(Addmonths(Period, -12)) AS PriorPeroid;    

LOAD Year,

     Month,

     makedate(Year,Month) as Period,

FROM

Period.xlsx

(ooxml, embedded labels, table is Feuil1);

Regards,