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 this Time/Date cell:
I want to separate the date and the hour from the cell,
how can I do that using the script?
Thank you very much
you can do that using 3 functions: Date, Time, Floor
Date(floor(DateTimeField)) as [DateTimeField - Date],Time(DateTimeField-floor(DateTimeField)) as [DateTimeField - Hour],
Date(floor(DateTimeField)) as [DateTimeField - Date],
Time(DateTimeField-floor(DateTimeField)) as [DateTimeField - Hour],
See the attached sample qvw.
View solution in original post
Try this simple
DATE(DateField) AS [Dates],
TIME(DateField) AS [Times],
You can get the Date and Time in separate fields in in Load Script as suggested by Sokkorn by using DATE() and TIME() methods instead of Calculated dimension. Calculated Dimensions leads to performance issues.
Hope this helps you.