Pivot Table is not showing Total Sum for each Date

[sjhussain]

Hello,

Am having problem showing sum of each date in Pivot Table.  I have a log date which is YYYYMMDDHHmmss and have converted it into MM/DD/YYYY hh:mm:ss and MM/DD/YYYY.  In the pivot table i want to show sum of each column (moving in sec., idle in sec., Eng ON in Sec. etc) for each Date (MM/DD/YYYY).  For some reason when I display it in the Pivot table it show single Date multiple times.

So in my case it should show the following:

1/18/2015 - sum of moving  / sum of idle etc.

1/21/2015 - sum of moving  / sum of idle etc.

1/22/2015 - sum of moving  / sum of idle etc.

1/26/2015 - sum of moving  / sum of idle etc.

etc. etc

Properties of the Pivot Table is as follows:

Will appreciate if someone can assist.

Thanks a lot.

[sjhussain · Accepted solution]

I found the solution in the following discussion:

____________________________________________________________________

QV don't group the dimension date in pivot table

Hi,

formatting your DateTime field is not enough. You need to take out the time portion of the field otherwise Qlikview will still group the Pivot Table by the individual distinct times within the given date. You can remove the timestamp and only keep the date by using the floor function.

Floor([Your DateTimeField])

________________________________________________________________________

I changed the Date to Date(Floor(log_dateindata_dt))

Now it is working perfect.