11 Replies Latest reply: Apr 28, 2017 3:18 AM by Alexandre HOLZHAMMER RSS

    [QlikView] How to select a date between two dates

    Alexandre HOLZHAMMER

      Hello,

      I would like to select from a list of selection a date. This selected date would then allow me to display the start date of the contract and the date of end of contract. So, we have a date interval in which our selected date must be included. I use "set analysis" but it does not work ".

       

      Capture.PNG

       

      =Sum({$

      <[Année début de validité] = {">=$(=Année1)"}>*

      <[Année fin de la période de validité] = {"<=$(=Année1)"}>*

      <[Mois début de validité] = {">=$(=Mois1)"}>

      *<Mois1 = {"<=$(=[Mois fin de la période de validité])"}>

      } [Début de validité])