topic Re: how to export qlikview pivot table containing negative hours to excel without replacing those negative value with ###### in QlikView https://community.qlik.com/t5/QlikView/how-to-export-qlikview-pivot-table-containing-negative-hours-to/m-p/773023#M1037041 <HTML><HEAD></HEAD><BODY><P>Thanks, i have my answer</P></BODY></HTML> Tue, 13 Jan 2015 09:12:46 GMT 2015-01-13T09:12:46Z how to export qlikview pivot table containing negative hours to excel without replacing those negative value with ###### https://community.qlik.com/t5/QlikView/how-to-export-qlikview-pivot-table-containing-negative-hours-to/m-p/773021#M1037039 <HTML><HEAD></HEAD><BODY><P>i am calculating the difference between two times: the reel time of entrance and the theoretical&nbsp; time with interval function wich work&nbsp; . the différence can be negative if the person come late.</P><P>the problem is that when i export my pivot table to excel, the negative numbers are shown like ##### or error.</P><P>So what should i do to have the number format as in qlikview</P></BODY></HTML> Mon, 12 Jan 2015 13:32:40 GMT https://community.qlik.com/t5/QlikView/how-to-export-qlikview-pivot-table-containing-negative-hours-to/m-p/773021#M1037039 2015-01-12T13:32:40Z Re: how to export qlikview pivot table containing negative hours to excel without replacing those negative value with ###### https://community.qlik.com/t5/QlikView/how-to-export-qlikview-pivot-table-containing-negative-hours-to/m-p/773022#M1037040 <HTML><HEAD></HEAD><BODY><P>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.</P><P></P><P>- Marcus</P></BODY></HTML> Mon, 12 Jan 2015 14:48:29 GMT https://community.qlik.com/t5/QlikView/how-to-export-qlikview-pivot-table-containing-negative-hours-to/m-p/773022#M1037040 marcus_sommer 2015-01-12T14:48:29Z Re: how to export qlikview pivot table containing negative hours to excel without replacing those negative value with ###### https://community.qlik.com/t5/QlikView/how-to-export-qlikview-pivot-table-containing-negative-hours-to/m-p/773023#M1037041 <HTML><HEAD></HEAD><BODY><P>Thanks, i have my answer</P></BODY></HTML> Tue, 13 Jan 2015 09:12:46 GMT https://community.qlik.com/t5/QlikView/how-to-export-qlikview-pivot-table-containing-negative-hours-to/m-p/773023#M1037041 2015-01-13T09:12:46Z Re: how to export qlikview pivot table containing negative hours to excel without replacing those negative value with ###### https://community.qlik.com/t5/QlikView/how-to-export-qlikview-pivot-table-containing-negative-hours-to/m-p/773024#M1037042 <HTML><HEAD></HEAD><BODY><P>arwa,</P><P></P><P>can you post your solution to this issue?</P><P></P><P>thanks!</P></BODY></HTML> Thu, 20 Aug 2015 12:40:35 GMT https://community.qlik.com/t5/QlikView/how-to-export-qlikview-pivot-table-containing-negative-hours-to/m-p/773024#M1037042 mphekin12 2015-08-20T12:40:35Z