Estimation of count using current trend

renjithpl — Tue, 18 May 2010 10:17:34 GMT

I have a project based qlikview question,

Fig 1, is the input box,

Number of Docs Assigned: is the Total documents assigned in the project.

Report Date is the date in the mid of the project.

EndDate is the end date of the Project.

Fig 2 is the pivot table, I just want a formula to find what is the "QC will get Completed" in the end of the project based on the current QC Productivity at the mid of the project.

Formula Used:

QC Completed till Date =Sum (if(QCDatecoded<=ReportDate,[Docs Qced]))

QC Hrs till date =Sum (if(QCDatecoded<=ReportDate, [QCReview Hours]))

QC Productiviy till date ="QC Completed till date "/"QC Hrs till date"

Basically, in the middle of the project, I just want to estimate what is the number of documents will get QCed in the end of the project, based on the current productivity.

Sample excel sheet:

QC Reviewer	Date Coded	QCReview Hours	Docs Qced
Ganesh	04-Sep Fri	1	16
Jason	04-Sep Fri	1	17
Mithun	04-Sep Fri	1	23
Mamta	04-Sep Fri	1	25
Pascal	04-Sep Fri	1	14
Total	04-Sep Fri	5	95
Ganesh	07-Sep Mon	1	14
Jason	07-Sep Mon	1	17
Mithun	07-Sep Mon	1	23
Mamta	07-Sep Mon	1	23
Pascal	07-Sep Mon	1	14
Total	07-Sep Mon	5	91
Ganesh	08-Sep Tue	1	20
Jason	08-Sep Tue	1	17
Mithun	08-Sep Tue	1	23
Mamta	08-Sep Tue	1	26
Pascal	08-Sep Tue	1	18
Total	08-Sep Tue	5	104
Ganesh	09-Sep Wed	1	20
Jason	09-Sep Wed	1	22
Mithun	09-Sep Wed	1	23
Mamta	09-Sep Wed	1	26
Pascal	09-Sep Wed	1	18

Please see the qvw attachement for further clarification.

topic Estimation of count using current trend in QlikView

Estimation of count using current trend