topic Re: how to use subfield() in QlikView

how to use subfield()

thabo2g5 — Wed, 26 Oct 2016 11:39:29 GMT

i have date data that is combined with time so i just need help to separate the data into two different columns , i'm still new in qlikview

shraddha_g — Wed, 26 Oct 2016 15:59:41 GMT

Can you provide sample data with expected output.?

Anonymous — Wed, 26 Oct 2016 16:04:09 GMT

do you mean , you would like to separate Date and time for a cilumn like 10/26/2016 12:01 PM ?

thabo2g5 — Fri, 28 Oct 2016 07:49:06 GMT

these 10/26/2016 12:01 PM are int the same column i want to separate them so that the date has its own table so as time

Anonymous — Fri, 28 Oct 2016 19:56:48 GMT

if 0/26/2016 12:01 PM is in "Datefield"

Date#(SubField(Datefield, ' ', 1),'MM/DD/YYYY') as Date............

time#(SubField(Dateield, ' ', -1),'HH:MM:SS') as Time ........

maxgro — Fri, 28 Oct 2016 20:03:36 GMT

you can use the floor (for date) and the frac (for time) functions

load

Date(Floor(Timestamp#(datetime, 'MM/DD/YYYY hh:mm tt'))) as date,

Time(Frac(Timestamp#(datetime, 'MM/DD/YYYY hh:mm tt'))) as time

inline [

datetime

10/26/2016 12:01 PM

];