8 Replies Latest reply: Nov 12, 2016 1:10 PM by Bill Duke RSS

    I am stuck and can't get a handle to solve this issue

    Bill Duke

      Using Qlik Sense 3.0 I am having a terrible time figuring this out, am I just missing the forest amongst the trees? Any help would be appreciated

       

      Result: I am looking for EffectiveDate (Fieldname) that fall between two variables vFromDate and vToDate. with an ExpriationDate (Fieldname) >= FromDate

       

      Variable Values:   vFromDate = 5/1/2016 and vToDate = 9/16/2016

       

      Formula:

      EffectiveDate<= vToDate AND ExpirationDate >= vFromDate

       

      Need this as an IF(EffectiveDate<= vToDate AND ExpirationDate >= vFromDate ,EffectiveDate) that I can use in a table

       

      Regards

      -bill