2 Replies Latest reply: Nov 26, 2010 4:07 AM by JurajChovan RSS

    Why all columns are not summed?

       

      hi friends,

      I have QlikView project where I'm selecting data about my projects. There is loading script:

       

      SourceProjectData:

      LOAD YIDMyProject,

      YMyProjectName,

      YMyProjectStartDate,

      YMyProjectEndDate,

      YIDMyDeliverable,

      YIDMyProjectDeliverable,

      YMyDeliverableName,

      YSourceHourTax,

      YMyDeliverableStartDate,

      YMyDeliverableEndDate,

      YMyDeliverableTotalInvoice,

      YDeliverableVRVforBusinessUnit,

      YMyDeliverableSource,

      YMySourceUtilization,

      YIDWorkingJob,

      YWorkingDate,

      YDurationOfWorking

      Resident TempSourceProjectData;

       

      from these data I build chart object (pivot table) where dimensions are:

      YMyProjectName

      YMyDeliverableName

      YMyDeliverableSource

      and expressions are:

      =Div((Sum(YDurationOfWorking)/2),60)&'h:'&Mod((Sum(YDurationOfWorking)/2),60)&'m'

      =((Sum(YDurationOfWorking)/2)/60)*YSourceHourTax

      Note: first expression converts number of minutes to format HHh:mmm (eg.6h:30m)

      and second calculates costs for source (eg.duration of work(=390min) * source hour tax(=13€) = 84,50€)

       

      There is chart properties - dimensions:

      error loading image

      and there is tab with expression (and formula for suspect expression):

      error loading image

      now is my question is - why no all columns are summed??? (eg."working duration" is summed for all deliverables (please see following image), but "source working costs" column is summed only if exist just one value (if exist more values (please see "deliverable P01-01" on following image) sum value is not available):

      error loading image

      any idea?