Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
swuehl
MVP
MVP

Try this as expression:

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

View solution in original post

8 Replies
mkirchhofer
Contributor III
Contributor III

Hi,

have upated your last Month Column.

Regards Mario

Not applicable
Author

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
Contributor III
Contributor III

Ok,

than use

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


at variables instead.

swuehl
MVP
MVP

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
Author

Excellent again swuehl.

Thank you both Guys!!

Not applicable
Author

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

do you guys know it?

mkirchhofer
Contributor III
Contributor III

Did you mean something like this?

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

Not applicable
Author

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

Have a great one!!