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)
If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
Attached is the format of the data in Excel:
I need to Extract Date and Time as separate fields.
I used this:
Timestamp("Changed Time Stamp",'D/MM/YYYY hh:mm:ss TT')
But am still not able to pull out date separately.
What can I use to get Date as its own and Time as its own?
May be this:
Date(Floor([Changed Time Stamp])) as Date,
Time(Frac([Changed Time Stamp])) as Time
View solution in original post
For more information, have a look at
QlikView Date fields
(applies also to timestamps)
Why don’t my dates work?
Get the Dates Right
I have executed