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!
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.