This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
Hello i have mixed Time Stamps on these fields, i want all the date fields to be like the first 5 date fields,
How can i convert this in Qlik Sense ?
View solution in original post
see in help menu.
Hello Henric, thanks for the reply,
I am glad to have a new insight in date formats, but i found the real problem :
It was on the source excel file, i wanted to change the comma delimiters to tabs in Excel, and after load it to Sense.
That was the problem, it automatically formatted the date fields very wrong when i tried to change delimiters in Excel.
Now i am trying to get WeekNumbers, DayName and Hours, to analyze more,
But i get nothing, what am i doing wrong ?
This is what i used :
GeoMakePoint(num([latitude]),num([longitude])) as GeoKey,
) ) as NewCD ,
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);
Please use the full script as advised by HIC.
) as New_Date_Value;
Load * inline [
Can you attach the excel file to demonstrate your issue?
Hi, i already did use it and formatted the datefields.
My Question was to get Hours, WeekNumbers and DayName.
You can not use a calculated field in the script...use a preceding load instead