Common Calendar - count not showing in table

[darren_dixon]

Hi,

Note - I've attached my QVW of the problem

I am trying to use the common calendar example linked here:

http://community.qlik.com/thread/66717

My problem is that the appointments are not adding to the table.

The total number of appointments should be 236779

The actual figures should look like this:

Month	Appointments
Total	236779
Dec	13519
Aug	13698
Sep	14630
Feb	16087
Nov	17336
Mar	17494
Jan	18179
Oct	18240
Jul	18791
Jun	26561
Apr	29237
May	33007

When I change the date to date(ActualStartDate) i get the following:

Month	sum( {<DateType={Order}>} OrderCounter)	sum( {<DateType={Shipment}>} ShipmentCounter)	sum( {<DateType={Order}>} Quantity)	Appointments	Travel Time
Total	6	11	621	236779	1959:03:00
Jan	2	1	203	0	0:00:00
Feb	1	3	103	0	0:00:00
Mar	3	0	315	0	0:00:00
Apr	0	1	0	0	0:00:00
Jun	0	1	0	0	0:00:00
Jul	0	0	0	0	1959:03:00
Aug	0	1	0	0	0:00:00
Sep	0	1	0	0	0:00:00
Oct	0	1	0	0	0:00:00
Nov	0	1	0	0	0:00:00
Dec	0	1	0	0	0:00:00
-	0	0	0	236779	0:00:00

When I change the date to Date(Floor(ActualStartDate) I get the following:

Month	sum( {<DateType={Order}>} OrderCounter)	sum( {<DateType={Shipment}>} ShipmentCounter)	sum( {<DateType={Order}>} Quantity)	Appointments	Travel Time
Total	6	11	621	236779	1959:03:00
Jan	2	1	203	219481	0:00:00
Feb	1	3	103	219750	0:00:00
Mar	3	0	315	233238	0:00:00
Apr	0	1	0	230957	0:00:00
May	0	0	0	231043	0:00:00
Jun	0	1	0	227118	0:00:00
Jul	0	0	0	233309	1959:03:00
Aug	0	1	0	221531	0:00:00
Sep	0	1	0	222419	0:00:00
Oct	0	1	0	223157	0:00:00
Nov	0	1	0	226379	0:00:00
Dec	0	1	0	222079	0:00:00

Thanks,

Darren