3 Replies Latest reply: Sep 1, 2010 1:23 PM by rbiscoeodi RSS

    Multiple if

      Hi All,

      I am new to QlikView and have found a lot of useful on these forums! However, I cannot work out how to solve the following problem:

      I have two calculations as follows:

       

      sum (if ([Entry Date] > (today()-(17*7)), [Total Hrs], '0'))
      - this shows me the total number of hours worked in the last 17 weeks

       

      Sum ( {$<Project_Type= {"Project"} >} [Total Hrs])
      - this shows me the total number of hours worked on a project (called project in this case) since time started being recorded.

       

      How do I combine the two so I can show total numbers of hours worked on a project in the last 17 weeks?

      Thanks!