Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.
very thanks, it is working.
right formula is following: Sum(((YDurationOfWorking/2)/60)*YSourceHourTax)