# Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

New Contributor III

## Maximum period per year with expansion sign

Hello, I have this problem, when I apply a formula to the following years MonthName(Max(Periodo), it returns the last month of the year with data, which is correct, but doing so in this way '\$(=MonthName(Max(Periodo)))', brings me the total value, could someone help me, I need the Value in quotation marks for a set analysis  Thank you

Tags (2)
1 Solution

Accepted Solutions
Contributor III

## Re: Maximum period per year with expansion sign

Hi Jonathan,

The difference between the \$() expressions and the ones without \$() is that the first is evaluated globally, for the entire data set. The latter is evaluated for each row, thus is taking into account the dimensions used in the table.

Have a look at the attached file. Is not the best solution, but I hope it will provide you with some useful hints.

Regards,

David

6 Replies
Honored Contributor III

## Re: Maximum period per year with expansion sign

Hi Jonathan,

'\$(=MonthName(Max(Periodo)))' is evaluated once per chart.

Regards,

Antonio

Esteemed Contributor II

## Re: Maximum period per year with expansion sign

try without the equal sign

\$(MonthName(Max(Periodo)))

Contributor III

## Re: Maximum period per year with expansion sign

Hi Jonathan,

The difference between the \$() expressions and the ones without \$() is that the first is evaluated globally, for the entire data set. The latter is evaluated for each row, thus is taking into account the dimensions used in the table.

Have a look at the attached file. Is not the best solution, but I hope it will provide you with some useful hints.

Regards,

David

New Contributor III

## Re: Maximum period per year with expansion sign

thanks for your answer Antonio

New Contributor III

## Re: Maximum period per year with expansion sign

I already tried, thanks for your answer Vinneeth

New Contributor III

## Re: Maximum period per year with expansion sign

Thank you very much for your answer, it is very useful to solve the problem that I have, thanks David