Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

mariamovasheli
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

Re: max Year Month

Try this

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

dwforest
Valued Contributor

Re: max Year Month

Please delete this duplicate thread....

mariamovasheli
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

keerthika
Contributor II

Re: max Year Month

Hi,

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

sasiparupudi1
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

Please share your calendar so that we can help you better

mariamovasheli
New Contributor III

Re: max Year Month

Hi, This is my calendar.

Calendar:

Load

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;

Re: max Year Month

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

sasiparupudi1
Honored Contributor III

Re: max Year Month

May Be try

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

Community Browser