2 Replies Latest reply: Dec 18, 2012 1:46 PM by mcrowell57 RSS

    Count units that were installed in scheduled month

      Hi all. Just beginning to learn Qlikview. I'm hung up on developing a chart that displays percent of units (serial number) installed within 3 days of the scheduled date.

       

      the data...

       

      Serial NumberInstall DateScheduled InstallDays +/- Scheduled
      1234510/5/201210/5/20120
      2345610/5/201210/9/20124
      3456710/1/201210/2/20121
      4567810/1/201210/5/20124

       

      ...so the metric would be 50% (2/4)

       

      my expression of the count of # Installed in month is working...

      =Count(SERIAL_NUMBER)

       

      my expression to get the count of # installed within 3 days of scheduled date is not working...

      if (DAY_ACT_EC.FULL_DATE-DAY_ECSCHED.FULL_DATE < 4, count(SERIAL_NUMBER), 0)

       

      Is this the correct approach to this or am I completely off in my method?

       

      Thanks for the help

       

      Mike