Why all columns are not summed?

[#1]

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:

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

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):

any idea?

[#2]

Hi.

I guess it's because the YSourceHourTax is outside of the aggregation function... Try to use the whole expression inside another aggregation function and it'll work.

Regards,

Montal.

[#3]

very thanks, it is working.

right formula is following: Sum(((YDurationOfWorking/2)/60)*YSourceHourTax)