Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Silambarasan1306
Creator III
Creator 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
sunny_talwar

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

Silambarasan1306
Creator III
Creator III
Author

Hi Sunny,

My chart dimension is Month.

sunny_talwar

May be this:

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

Silambarasan1306
Creator III
Creator III
Author

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

sunny_talwar

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