Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
silambarasan130
Contributor III

Getting maximum Date data by each month in trend chart..??

Hi All,

I Need to get only maximum date of each month  data that can be showed in trend chart ...

Could anyone help with this problem..

Thank you

5 Replies

Re: Getting maximum Date data by each month in trend chart..??

What is your chart dimension? Can you provide more information on your dimensions and expressions?

silambarasan130
Contributor III

Re: Getting maximum Date data by each month in trend chart..??

Hi Sunny,

My chart dimension is Month.

Re: Getting maximum Date data by each month in trend chart..??

May be this:

FirstSortedValue(Aggr(Sum(Sales), Date), -Aggr(Date, Date))

silambarasan130
Contributor III

Re: Getting maximum Date data by each month in trend chart..??

Hi Sunny,

It is not working in YTD,QTD Concept. When i select some month, it displays only the selected month data.

can you help with this,'

Thank you

Re: Getting maximum Date data by each month in trend chart..??

Would you be able to share a sample with the expected ouput?