Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
My excel sheet date field have different formates of dates are available..so i need to make a proper format.How can achieve this.
See the attached
post your data file
Hi Karthik,
Please attach the excel file or your sample application. Thank you.
as first tip, check "Date#" in Qlikview help
this function may help you
Date | sales | ||
1/2/2009 | 400 | dd-mm-yyyy | |
2/13/2009 | 5000 | mm-dd-yyyy | |
2009/15/2 | 3000 | yyyy-dd-mm | |
3/17/2009 | 1 | mm-dd-yyyy | |
Required format "DD-MM-YYYY" |
Try this may be:
Date(Alt(Date#(Date, 'DD-MM-YYYY'), Date#(Date, 'MM-DD-YYYY'), Date#(Date, 'YYYY-DD-MM')), 'DD-MM-YYYY')
Only problem would be when you have a date like 01/02/2015. Would you want QlikView to interpret this like Jan 2nd 2015 or Feb 1st 2015?
Hi Karthik,
Try this:
TableName:
LOAD Date(Date#(Date, 'DD-MM-YYYY'), 'DD-MM-YYYY') As Date,
Sales
FROM <Filename>.xlsx;
V.
A combination of alt() and date#() should work.
Alt (date#(Date, 'MM/DD/YYYY'),
date#(Date, 'YYYY/DD/MM'),
date#(Date, 'MM/DD/YYYY)
)
You can add additional date# functions in here to match any additional date formats you have in your source data.
Marcus
hi,
First Use interpretation function and use formatting function to make uniform date format.
still an issue.
Please post sample data and script
Regards
Neetha