4 Replies Latest reply: Aug 9, 2018 3:28 AM by abdulaziz hassan aldabbagh RSS

    Count values based on Plan Start Date Range

    Kyle Hahn



      I'd greatly appreciate some help writing a formula within a KPI. My question is very similar to this one: https://community.qlik.com/message/1528073#1528073


      Our data source is a project management data base, and we want to know the count of charters that have Plan Start dates within the next 60 days (i.e. Charters that will be converting to Projects within the next 60 days).


      How can I adjust the below formula to capture a count of charters with Project Plan Dates greater than Today, but less than 60 days from Today?

      Count({<[Plan Start Date] = {"$(='<' & Date(Today()))"}, [PCI Type] = {'CHARTER'}>} [PCI Type])


      Thanks so much!