Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

marcoebner
New Contributor II

Data from the last Timeline for every Year

I have a list of hundreds of projects . Each project has many timelines . I need the latest timeline annually.

Tags (1)
2 Replies
Employee
Employee

Re: Data from the last Timeline for every Year

Perhaps change the dimension

from:   <Date>

To:    Aggr( Max( <Date>) , <Project>, <Year> )

You may need to change your load editor to include a Year field

load

     <Date>

from <>

->

load

     <Date>

     Year(<Date>) as Year

from <>

marcoebner
New Contributor II

Re: Data from the last Timeline for every Year

Good solution , thanks for the support