Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

leacueva
New Contributor II

Time Duration Formatting

Hello Qlikers!

I need help...

On my spreadsheet that I import into my Qlik Sense App, I have a column labeled "Duration" which tracks the duration of phone calls.

When the spreadsheet gets imported to Qlik, it is read as a timestamp rather than a duration.  How do I fix this?  Also, in the column on the spreadsheet I have a few data entries "email", which I don't need to track in Qlik at this time, but I don't want to remove the entries from the spreadsheet.  I just want Qlik to ignore that data.  Thank you!

Spreadsheet.PNGData Manager.PNG

Tags (1)
5 Replies
YoussefBelloum
Esteemed Contributor

Re: Time Duration Formatting

Hi,

to show only time values, you can do this:

if(DURATION<>'Email', DURATION)

to convert your time field into minutes, yo can use the Minute() function.

Minute(DURATION)

mgomezlor
New Contributor III

Re: Time Duration Formatting

May be like this

IF(match(DURATION, 'Email')=0, Interval(DURATION, 'hh:mm:ss') )

leacueva
New Contributor II

Re: Time Duration Formatting

Thank you!  Would you recommend doing this in the Data Load Editor as below or somewhere else?Capture.PNG

leacueva
New Contributor II

Re: Time Duration Formatting

Thank you!  Would you recommend doing this in the Data Load Editor as below or somewhere else?

I tried it in the Data Load Editor but it didn't change anything in my charts and said I have a synthetic key.  Also the Data Manager section now says "Data Profiling Could Not Be Completed".  Makes me think I might be changing the expression in the wrong place.  Capture.PNG

sasiparupudi1
Honored Contributor III

Re: Time Duration Formatting

In the load editor

Load

Col1,

If (isnum (Duration),Duration,0) as Duration,

Col3

.

.

FROM

Your excel file;

Community Browser