topic Re: Last n period (trigger) in QlikView

Last n period (trigger)

nicogene — Sun, 29 Sep 2013 11:06:22 GMT

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é.

Re: Last n period (trigger)

Anonymous — Sun, 29 Sep 2013 17:46:42 GMT

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

Re: Last n period (trigger)

Clever_Anjos — Sun, 29 Sep 2013 21:53:52 GMT

Try this

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

Re: Last n period (trigger)

MayilVahanan — Mon, 30 Sep 2013 04:54:25 GMT

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))

Re: Last n period (trigger)

tresB — Mon, 30 Sep 2013 05:05:23 GMT

May be like attached sample.

Re: Last n period (trigger)

qlikpahadi07 — Mon, 30 Sep 2013 06:20:11 GMT

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

Re: Last n period (trigger)

rajni_batra — Mon, 30 Sep 2013 06:34:57 GMT

Hello Nicolas,

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

Regards,

Rajni

Re: Last n period (trigger)

struniger — Mon, 30 Sep 2013 08:15:03 GMT

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

Re: Last n period (trigger)

jonathandienst — Mon, 30 Sep 2013 08:40:58 GMT

Try Max(Period) - 12

Regards

Jonathan

Re: Last n period (trigger)

v_iyyappan — Mon, 30 Sep 2013 09:56:34 GMT

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,

Re: Last n period (trigger)

Mon, 30 Sep 2013 10:28:51 GMT

Hi,

please use =AddMonths( (max(Period)),-12)

Good luck!

Rainer

Re: Last n period (trigger)

bismart — Mon, 30 Sep 2013 10:34:38 GMT

Use

=addmonths(max(Period),-12) as your expression for max Period - 12