7 Replies Latest reply: Feb 25, 2016 9:18 AM by Sunny Talwar RSS

    Value in daterange

    Isabelle Timmermans

      Hi,

       

      I'm new to Qlik Sense and I have the following problem:

       

      I have a project start and end date for multiple customers in one table:

      Costumer nameProjectnameStartdate projectEnddate project
      Costumer AProject X19-5-20166-6-2016
      Costumer AProject Y7-6-201613-7-2016
      Costumer BProject Z27-6-201625-7-2016

       

      And I have a table with my spend and other values on datelevel.

      Customer nameDateSpendOther Value
      Costumer A25-5-20165...
      Costumer A1-6-20166...
      Costumer A

      9-6-2016

      9...
      Costumer A1-7-20161...
      Costumer A

      29-6-2016

      5...
      Costumer B14-7-20162...
      Costumer B21-7-201612...

       

      Is there a way to check if the date in the second table matches one of the dateranges in the first table and then add the correct projectname to the second table?

       

      Or is it easier to make a Project-Master Calander for the first table?

       

      Thanks,

       

      Isabelle