topic Re: Convert timestamp string to num in text box in QlikView

Convert timestamp string to num in text box

Anonymous — Wed, 29 Jul 2015 15:36:45 GMT

hi,

I have a string 2015-05-26 12:34:38, how can I find its numeric value ?

I tried

=num(Timestamp

(

Timestamp#(2015-05-26 12:34:38,'YYYY-MM-DD HH:MM:SS')

,'YYYY-MM-DD HH:MM:SS'

)

doesnt not work

Re: Convert timestamp string to num in text box

swarup_malli — Wed, 29 Jul 2015 15:41:00 GMT

Try using this in the test box

=num('2015-05-26 12:34:38')

Re: Convert timestamp string to num in text box

sunny_talwar — Wed, 29 Jul 2015 16:48:08 GMT

Try this with single quotes around your time when you are using it by typing it out:

=Num(Timestamp#('2015-05-26 12:34:38', 'YYYY-MM-DD HH:MM:SS'))

When using a fieldname you can do this:

=Num(Timestamp#(FieldName, 'YYYY-MM-DD HH:MM:SS'))

Re: Convert timestamp string to num in text box

swuehl — Wed, 29 Jul 2015 17:10:06 GMT

Please note that format code 'MM' denotes month, not minutes:

=Num(Timestamp#('2015-05-26 12:34:38', 'YYYY-MM-DD hh:mm:ss'))

Without testing, I think Swarup's expression will also work as long as QV recognizes the string matching it with it's default timestamp format. Stating a explicite format code like above should work anyway.

Re: Convert timestamp string to num in text box

sunny_talwar — Wed, 29 Jul 2015 17:31:58 GMT

You are right, my bad Stefan. Correct Expressions should be:

=Num(Timestamp#('2015-05-26 12:34:38', 'YYYY-MM-DD hh:mm:ss'))

=Num(Timestamp#(FieldName, 'YYYY-MM-DD hh:mm:ss'))