Common Calendar - count not showing in table

darren_dixon — Fri, 26 Jul 2013 09:52:17 GMT

Hi,

Note - I've attached my QVW of the problem

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

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:

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

topic Common Calendar - count not showing in table in QlikView