9 Replies Latest reply: Jun 16, 2011 6:23 AM by Jonathan Street RSS

    Sum Values where another field is not null...

      Hi
      I'm pretty new to QlikView and have hit a brick wall, normally I have found something on the community to answers my question, but not this time.  What I need is a sum of Charge Out Rates in the selected year, where the person has a time budget.  Sample of data is shown below.  For example if I select year 2011/12 I would want to return £380 (Name1 + Name3).
      I have tried:
      if(IsNull(TIME_BUDGET)=0,(sum({$<CO_Fin_Year = Period_Fin_Year>} charge_out_rate)),0)
      Any help really appreciated.
      NameCharge_Out_RateCO_Fin_YearTIME_BUDGET
      Name11852009/10100
      Name11852010/11100
      Name11952011/12100
      Name202008/09
      Name202009/10
      Name202010/11
      Name202011/12
      Name21401996/97
      Name21402007/08
      Name31702009/1050
      Name31752010/1150
      Name31852011/1250