how to export qlikview pivot table containing negative hours to excel without replacing those negative value with ######
i am calculating the difference between two times: the reel time of entrance and the theoretical time with interval function wich work . the différence can be negative if the person come late.
the problem is that when i export my pivot table to excel, the negative numbers are shown like ##### or error.
So what should i do to have the number format as in qlikview
It's a excel-feature not to be able to show negative times (unless you changed a global excel-setting which isn't recommended). You could format this column with a normal decimal number-format, hide it in excel but calculate with it if necessary and transform it in excel in a string.
