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
