Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Common Calendar - count not showing in table

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:

MonthAppointments
Total236779
Dec13519
Aug13698
Sep14630
Feb16087
Nov17336
Mar17494
Jan18179
Oct18240
Jul18791
Jun26561
Apr29237
May33007

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

Monthsum(
{<DateType={Order}>}
OrderCounter)
sum(
{<DateType={Shipment}>}
ShipmentCounter)
sum(
{<DateType={Order}>}
Quantity)
AppointmentsTravel Time
Total6116212367791959:03:00
Jan2120300:00:00
Feb1310300:00:00
Mar3031500:00:00
Apr01000:00:00
Jun01000:00:00
Jul00001959:03:00
Aug01000:00:00
Sep01000:00:00
Oct01000:00:00
Nov01000:00:00
Dec01000:00:00
-0002367790:00:00

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

Monthsum(
{<DateType={Order}>}
OrderCounter)
sum(
{<DateType={Shipment}>}
ShipmentCounter)
sum(
{<DateType={Order}>}
Quantity)
AppointmentsTravel Time
Total6116212367791959:03:00
Jan212032194810:00:00
Feb131032197500:00:00
Mar303152332380:00:00
Apr0102309570:00:00
May0002310430:00:00
Jun0102271180:00:00
Jul0002333091959:03:00
Aug0102215310:00:00
Sep0102224190:00:00
Oct0102231570:00:00
Nov0102263790:00:00
Dec0102220790:00:00

Thanks,

Darren