5 Replies Latest reply: Apr 11, 2018 7:15 PM by Lea Cueva RSS

    Time Duration Formatting

    Lea Cueva

      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