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



      EffectiveDate<= vToDate AND ExpirationDate >= vFromDate


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