Supract two field values in Qlikview

[Anonymous]

Hi ...

  I have two fields like...

First field contains:

Start date time:05:01:13:113

End date Time:05:01:13:313

I want to find out end date time-start date time ..IN Qlikview how can i do this?

Please can any one help me?

[tresesco]

Most likely it's a format issue. Could you post sample data in CALL_DATA field ?

[Anonymous]

Hi...

  I dont have data base installation in my system....

  Remotely i got the data of CALL_Data...

I just send to you screenshot of data....

[tresesco]

If this is how your base data looks like, you should rather try like:

Interval(Time#(myENDDATETIME, 'hh:mm:ss:ffff') - Times#(mySTARTDATETIME, 'hh:mm:ss:ffff'), 'hh:mm:ss:fff') as ivr