MTD Issue

Fri, 17 Mar 2017 11:19:37 GMT

Hello All,

I have a scenario where i need to calculate MTD and YTD hoursworked of a an individual. I am getting the total right but in the straight table I am not getting the desired output.

I have got this output

Date	Name	Hours	StartTime	EndTime	Vendor	Work_type	Class	Job Description	MTD	YTD
									13.9	13.9
2017-01-01	Adam Newman	6.9	01-01-2017 07:01:00	01-01-2017 13:55:00	PLANT ENGINEERING CONSTRUCTION PTE	Contracator	DIRECT	FORMAN - FOREMAN	6.9	6.9
2017-01-02	Adam Newman	0.2	02-01-2017 17:45:00	02-01-2017 18:00:00	PLANT ENGINEERING CONSTRUCTION PTE	Contracator	DIRECT	FORMAN - FOREMAN	0.2	0.2
2017-01-03	Adam Newman	6.8	03-01-2017 07:01:00	03-01-2017 13:54:00	PLANT ENGINEERING CONSTRUCTION PTE	Contracator	DIRECT	FORMAN - FOREMAN	6.8	6.8

But i need something like this:

Date	Name	Hours	StartTime	EndTime	Vendor	Work_type	Class	Job Description	MTD	YTD
									13.9	13.9
2017-01-01	Adam Newman	6.9	01-01-2017 07:01:00	01-01-2017 13:55:00	PLANT ENGINEERING CONSTRUCTION PTE	Contracator	DIRECT	FORMAN - FOREMAN	6.9	6.9
2017-01-02	Adam Newman	0.2	02-01-2017 17:45:00	02-01-2017 18:00:00	PLANT ENGINEERING CONSTRUCTION PTE	Contracator	DIRECT	FORMAN - FOREMAN	7.1	7.1
2017-01-03	Adam Newman	6.8	03-01-2017 07:01:00	03-01-2017 13:54:00	PLANT ENGINEERING CONSTRUCTION PTE	Contracator	DIRECT	FORMAN - FOREMAN	13.9	13.1

The Exptression which i am using is : =SUM({<date_num={">=$(vMTD_Start)<=$(vMTD_End)"}>}Hours)

Tried the rangesum function but its not working.

Any help would be appreciated.

Re: MTD Issue

Anil_Babu_Samineni — Fri, 17 Mar 2017 15:31:33 GMT

Which chart is this, We have option called Full Accumulation ?

Re: MTD Issue

sunny_talwar — Fri, 17 Mar 2017 15:32:40 GMT

This should work if your original expression worked

=RangeSum(Above(TOTAL SUM({<date_num={">=$(vMTD_Start)<=$(vMTD_End)"}>}Hours), 0, RowNo(TOTAL)))

or use the full accumulation on the expression tab of chart properties (only available for straight table)

Re: MTD Issue

Anil_Babu_Samineni — Fri, 17 Mar 2017 15:32:57 GMT

Rangesum(Below(SUM({<date_num={">=$(vMTD_Start)<=$(vMTD_End)"}>}Hours),0),Above(Hours,1,1000))

topic MTD Issue in QlikView

MTD Issue

Re: MTD Issue

Re: MTD Issue

Re: MTD Issue