Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Consecutive Month

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

1 Solution

Accepted Solutions
MVP
MVP

Consecutive Month

Try this as expression:

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

8 Replies
mkirchhofer
New Contributor III

Re: Consecutive Month

Hi,

have upated your last Month Column.

Regards Mario

Not applicable

Re: Consecutive Month

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.

mkirchhofer
New Contributor III

Re: Consecutive Month

Ok,

than use

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


at variables instead.

MVP
MVP

Consecutive Month

Try this as expression:

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

Not applicable

Consecutive Month

Excellent again swuehl.

Thank you both Guys!!

Not applicable

Consecutive Month

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

do you guys know it?

mkirchhofer
New Contributor III

Re: Consecutive Month

Did you mean something like this?

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

Not applicable

Consecutive Month

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

Have a great one!!

Community Browser