Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
george55
Partner - Creator III
Partner - Creator III

Max Date, Aggr Months

Hi all,

Need the Max Date of a moth and take their value. And this for each month. This formula brings correct results:

Sum({<%Date={'$(=Max(%Date))'}>} TimetoCount )

but it shows only 1 month, only the last month (Mär). Result should look like this below but with the formula above.

Thanks.

2020.0325-170850.jpg

Labels (1)
  • SaaS

1 Solution

Accepted Solutions
lorenzoconforti
Specialist II
Specialist II

Try something along these lines:

=FirstSortedValue(aggr(sum(TimetoCount ), Date ),-aggr(only(Date) ,Date))

View solution in original post

1 Reply
lorenzoconforti
Specialist II
Specialist II

Try something along these lines:

=FirstSortedValue(aggr(sum(TimetoCount ), Date ),-aggr(only(Date) ,Date))