Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a value in QlikSense displayed in HH:MM:SS format, for example 26:12:12, representing 26 hours, 12 minutes, 12 seconds.
This displays fine in a chart but when I export to excel, if the value is over 24 hours, the value displays as a date with an associated time element. The time element is the HH:MM:SS of the incomplete day e.g. 2:12:12 in the above scenario.
We can ask the user to change the excel format but that is not great. we want to continue to show hh:MM:ss in Qlik.
Any suggestions of forcing excel to show the right format?
neve encountered this exact scenario but why dont you try converting that column into a text e.g. ' '& yourcolumn