topic Re: Consecutive Month in QlikView

Consecutive Month

Thu, 19 Jan 2012 16:08:57 GMT

Hi all, I´m trying to get the last month value and I can´t make it, could some body help me to get the consevutive month number or if you could help me to get the last month value I would be thankfull.

I attached the App.

Thanks!!

Re: Consecutive Month

mkirchhofer — Thu, 19 Jan 2012 16:26:14 GMT

Hi,

have upated your last Month Column.

Regards Mario

Re: Consecutive Month

Thu, 19 Jan 2012 16:37:33 GMT

Thank´s mkirchhofer but the problem is when I select January 2012 in the las month value I should get December 2011 but it returns 0.

Re: Consecutive Month

mkirchhofer — Thu, 19 Jan 2012 16:41:44 GMT

Ok,

than use

=chr(39)&Date(MonthStart(Max([Mes-Año]))-1,'MMM YYYY')&chr(39)

at variables instead.

Consecutive Month

swuehl — Thu, 19 Jan 2012 16:48:31 GMT

Try this as expression:

sum({$<[Mes-Año] = {'$(=date(addmonths(max([Mes-Año]), -1),'MMM YYYY'))'}, Mes=,Año= >}[Valor Surcharge Nuevo])

Consecutive Month

Thu, 19 Jan 2012 17:03:48 GMT

Excellent again swuehl.

Thank you both Guys!!

Consecutive Month

Thu, 19 Jan 2012 23:20:53 GMT

One more last question guys, How could I get the previous Quarter?

do you guys know it?

Re: Consecutive Month

mkirchhofer — Fri, 20 Jan 2012 08:48:28 GMT

Did you mean something like this?

I'm not sure about performance, maybe there's a better way!

Consecutive Month

Fri, 20 Jan 2012 16:29:40 GMT

Yes!!, that´s what I needed it, Thank you both!!

Have a great one!!