title: QlikView Script Count Conditional Occurrences
body: <p>I have a data set that shows engineer visits and the type of job attended. </p>
  
  <p>Engineer's Visit Table:</p>
  
  <pre><code>OrderNum, Engineer, Job Type, Date  
  1         John      Install   01/04/15  
  2         Phil      Remove    02/04/15
  3         George    Install   01/04/15
  4         George    Replace   02/04/15
  5         George    Replace   03/04/15
  6         John      Install   01/04/15
  7         John      Install   01/04/15
  8         John      Replace   02/04/15
  9         John      Remove    02/04/15
  </code></pre>
  
  <p>For the example table above - I would like to show for each engineer (but using John as an example): </p>
  
  <ul>
  <li>His predominant job type was "Install";</li>
  <li>The total number of jobs he attended was 5;</li>
  <li>He worked for 3 days;</li>
  <li>Meaning he attended 1.67 jobs per day.</li>
  </ul>
  
  <p>I was attempting to add this to the load script using various additional columns but I'm having trouble getting an aggr/count statement to work.</p>
  
  <p>Is this a reasonable approach or am I going about it the wrong way?</p>
  
  <p>Thanks.</p>