3 Replies Latest reply: Sep 20, 2012 9:54 AM by Mark Perry RSS

    Set Analysis - Want to fix value to just data from one year

      Hi,

       

      I'm writing a report to show the cost of delivering a service dependant on staff costs. I have loaded data from a timesheet app for 2011, and then decided that number of mins worked / annual salary = cost per minute (there's probably a million reasons why this is flawed but let's just stick to the QlikView stuff).

       

      So I have created a variable called costPerMinute2011 and inserted the following expression into it.

       

        
      =
      num(sum({$<ProNetSummaryYear={2011}>}SalaryWithOnCost)/sum({$<ProNetSummaryYear={2011}>}ProNetSummaryMinutes),0.00) 
      
      
      

       

      If I select the name of a specific employee I get back the value I would expect.

       

      But if I want to see data for a specific month, and I change the value of ProNetSummaryMonth to 'August', for example, the value of the variable changes and it's massively over inflating the costs.

       

      I don't really understand what's going on here - can anyone offer some advice?