Set minimum date as only date, when diverse dates exist

[Anonymous]

Dear all together, greetings from windy germany,

I got a probably simple question. I have an excel sheet, which looks like this:

Project	Date	Value
500	1.1.2017	1000
505	5.6.2017	5000
506	6.6.2017	2500
508	5.6.2017	3200
500	5.6.2017	200
540	10.6.2017	5400
564	5.6.2017	2000
576	5.6.2017	6000
500	30.6.2017	2000

As it can be seen, Project 500 exists three times. Every time the project is listed up new (newer date), it means that it's value has rised up about the value shown on the right collumn. In my Sense App I have set a filter, that filters the date of the Project start. So f.e. I set a filter for "June 2017". Qlik shows me beneath many other projects also project "500". My problem is, that it should not be shown, as the date benath project "500" just shows the date of when the value has rised up. But the start of the project was on January the first.

I tried to set <min(Date) as Date>, but that doesn't work. How can I adjust my script so that the project is just shown once, when the earliest date concerning the project is set?

Thanks for the replies

[agigliotti]

if you think your question has been answered please mark the reply as correct.