10 Replies Latest reply: Jan 19, 2018 8:25 AM by Andrea Gigliotti RSS

    Set minimum date as only date, when diverse dates exist

    Tom Müller

      Dear all together, greetings from windy germany,

       

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

       

      ProjectDateValue
      5001.1.20171000

      505

      5.6.20175000
      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