# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

New Contributor III

## max Year Month

hello,

I want to show max month on the line chart.

I am Using this formula and its not Working and can you please advise me something.

sum({\$<Year = {\$(=max(Year))}, Month = {\$(=max(Month))}>} FactSoldAmount)

8 Replies
MVP

## Re: max Year Month

Try this

Sum({\$<Year = {\$(=Max(Year))}, Month = {'\$(=Max(Month))'}>} FactSoldAmount)

Valued Contributor

## Re: max Year Month

New Contributor III

## Re: max Year Month

hi, It doesn't work without selection. If I select 2018 or another year it is correct but Without it it Doesn't Show anything

Contributor II

## Re: max Year Month

Hi,

As sunny said the above expression will work fine . Can you share your app to check

Honored Contributor III

## Re: max Year Month

I think you need to use date field to filter you data rather than using year and month fields

New Contributor III

## Re: max Year Month

Hi, This is my calendar.

Calendar:

Distinct

%lnk_date,

Date(%lnk_date) as Date,

Day(date) as day,

year(%lnk_date) as Year,

month(%lnk_date) as Month,

'Q' & ceil(month(%lnk_date)/3) as Quarter,

'Q' & ceil(month(%lnk_date)/3)  & '`' &  right(year(%lnk_date),2)  as [Year Quarter],

ceil(month(%lnk_date)/3) as %QuarterNum,

month(%lnk_date)  & '`' &  right(year(%lnk_date),2)  as [Year Month] ,

year(%lnk_date)*100 + month(%lnk_date) as %ym

Resident  GasOperatingSales;

MVP

## Re: max Year Month

Would you be able to share a sample or some sample data to look at this?

Honored Contributor III

## Re: max Year Month

May Be try

Sum({\$<Year =, Month = , [Year Month]={"\$(=Max( [Year Month]))"}>} FactSoldAmount)