# 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

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

New Contributor III

## Re: Consecutive Month

Ok,

than use

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

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?

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