Solved: Re: Dynamic labels - Qlik Community

Anonymous · ‎2016-06-25

Hi All,

I need dynamic labels. I'm comparing last year current Month VS this year current Month.

Ex: last May VS current May.

May-2016 =max([Month Period])

How can I get May-2015 .

Please help me out.

Thanks,

Krishna.

swuehl · ‎2016-06-25

If your Month-Year values show a numeric representation that represents a date, use QlikView date functions like AddYears():

=MonthName(AddYears(Max([Month Period]),-1))

swuehl · ‎2016-06-25

If your Month-Year values show a numeric representation that represents a date, use QlikView date functions like AddYears():

=MonthName(AddYears(Max([Month Period]),-1))

Anonymous · ‎2016-06-25

Thanks Swuehl