Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
dseelam
Creator II
Creator II

Dates issue

Hello All,

I am having this strange issue

Created dates depending on shipment_date

Please check Attached files, some how its missing ShipDate for only 4/1 to 4/9, 5/1 to 5/9, 6/1 TO 6/9, 7/1 TO 7/9, 8/1 TO 8/8 OF 2016

Totally it has dates from 4/1/16 to 8/8/16

please help

Thanks in advance

1 Solution

Accepted Solutions
sunny_talwar

Try with this:

SET ShipmentDate = date#(SHIPMENT_DATE,'MM/DD/YYYY h:mm');

View solution in original post

5 Replies
sunny_talwar

Try with this:

SET ShipmentDate = date#(SHIPMENT_DATE,'MM/DD/YYYY h:mm');

dseelam
Creator II
Creator II
Author

Thanks Sunny

dseelam
Creator II
Creator II
Author

Sunny,

I have an other file attached to original post using the same code you sent me except using mcks*.xls] in from statement but doing so not bringing dates from 8/9 to 8/21 in new file I attached

SET ShipmentDate = date#(SHIPMENT_DATE,'MM/DD/YYYY h:mm');

LOAD SHIPMENT_DATE,
Date(floor($(ShipmentDate))) as ShipDate,
num(floor($(ShipmentDate))) as ShipDateNum,
Month(floor($(ShipmentDate))) as ShipDateMonth,
Day(floor($(ShipmentDate))) as ShipDateDay,
Year(floor($(ShipmentDate))) as ShipDateYear,
date(monthstart($(ShipmentDate)),'MMM YYYY') as ShipDateMonthYear,
// ShipDate,
   [sum(GROSS_SALES)]
FROM

(
biff, embedded labels, table is Sheet1$);

sunny_talwar

The new file you attached is a csv file. Is it even loading?

dseelam
Creator II
Creator II
Author

Yes it worked out I think I saved in CSV and Xls files