topic Remove Am and pm from Time Interval in QlikView

Remove Am and pm from Time Interval

Wed, 09 Jul 2014 17:13:56 GMT

I have created a field by using

INTERVAL(TIMESTAMP(ReloadTime(),'hhh:mm:ss')- INTERVAL(TIMESTAMP(EvDate),'hhh:mm:ss')) AS Trial,

And I believe the data is correct However, I would like to remove the AM and PM Fields, , I have attached a ss . Thank You in advance .

Re: Remove Am and pm from Time Interval

Wed, 09 Jul 2014 17:28:30 GMT

Perhaps a string function like subfield would work:

=subset(Trial,' ', 1)

Matt

Re: Remove Am and pm from Time Interval

Greg_Williams — Wed, 09 Jul 2014 17:45:36 GMT

Perhaps this might help (with formatting) of the timestamp.

Time format including AM/PM | Qlik Community

Re: Re: Remove Am and pm from Time Interval

Wed, 09 Jul 2014 17:54:11 GMT

I ended up using Subfield at the script level

SubField(INTERVAL(TIMESTAMP(ReloadTime(),'hhh:mm:ss')- INTERVAL(TIMESTAMP(EvDate),'hhh:mm:ss')),' ',1))

Which is giving me

I am getting what I need but do you think it is the wrong way?

Will I have problems doing aggregations on this, it seems to be working as of now

Re: Remove Am and pm from Time Interval

maxgro — Wed, 09 Jul 2014 17:56:23 GMT

=interval(reloadtime() - timestamp(today()-1), 'hh:mm:ss')

=interval(reloadtime() - timestamp(EvDate), 'hh:mm:ss')

Re: Remove Am and pm from Time Interval

jaimeaguilar — Wed, 09 Jul 2014 18:04:20 GMT

Hi,

Enclose your formula with Time(Your_Formula, 'hh:mm:ss'). This way your time data will be displayed just in hours, minutes and seconds disregarding the AM/PM,

regards

Re: Remove Am and pm from Time Interval

Wed, 09 Jul 2014 18:11:06 GMT

That Worked perfectly Thank You so much!