topic Re: Data issue after exporting in QlikView https://community.qlik.com/t5/QlikView/Data-issue-after-exporting/m-p/99634#M755541 <HTML><HEAD></HEAD><BODY><P>Hey it worked for me </P></BODY></HTML> Mon, 24 Sep 2018 12:03:28 GMT himabinduch 2018-09-24T12:03:28Z Data issue after exporting https://community.qlik.com/t5/QlikView/Data-issue-after-exporting/m-p/99630#M755537 <HTML><HEAD></HEAD><BODY><P>HI All,</P><P></P><P>I have a&nbsp; straight table in my application and i have huge data.</P><P>when i am exporting data to excel i am facing some issue my data </P><P>one of the text field convert into date format.</P><P></P><P>my data as below. mu line number suppose to be 1-4,1-3,1-2&nbsp; like that.</P><P>&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 448px;"><TBODY><TR><TD height="20" width="64">order#</TD><TD width="64"><STRONG>Line number</STRONG></TD><TD width="64">change date</TD><TD width="64">operating unit</TD><TD colspan="2" width="128">change by name</TD></TR><TR><TD align="right" height="20">834680</TD><TD align="right" class="xl63">1-Apr</TD><TD align="center" class="xl64">########</TD><TD>QTIL OU</TD><TD>NCHOU</TD></TR><TR><TD align="right" height="20">834680</TD><TD align="right" class="xl63">1-Apr</TD><TD align="center" class="xl64">########</TD><TD>QTIL OU</TD><TD>NCHOU</TD></TR><TR><TD align="right" height="20">834680</TD><TD align="right" class="xl63">1-Apr</TD><TD align="center" class="xl64">########</TD><TD>QTIL OU</TD><TD colspan="2">FEEDER SYSTEM</TD></TR><TR><TD align="right" height="20">834680</TD><TD align="right" class="xl63">1-Apr</TD><TD align="center" class="xl64">########</TD><TD>QTIL OU</TD><TD colspan="2">FEEDER SYSTEM</TD></TR><TR><TD align="right" height="20">834680</TD><TD align="right" class="xl63">1-Apr</TD><TD align="center" class="xl64">########</TD><TD>QTIL OU</TD><TD colspan="2">FEEDER SYSTEM</TD></TR><TR><TD align="right" height="20">834680</TD><TD align="right" class="xl63">1-Apr</TD><TD align="center" class="xl64">########</TD><TD>QTIL OU</TD><TD colspan="2">FEEDER SYSTEM</TD></TR><TR><TD align="right" height="20">838390</TD><TD align="right" class="xl63">1-Mar</TD><TD align="center" class="xl64">########</TD><TD>QTIL OU</TD><TD>SHERRYL</TD></TR><TR><TD align="right" height="20">838390</TD><TD align="right" class="xl63">1-Mar</TD><TD align="center" class="xl64">########</TD><TD>QTIL OU</TD><TD>SHERRYL</TD></TR><TR><TD align="right" height="20">838390</TD><TD align="right" class="xl63">1-Mar</TD><TD align="center" class="xl64">########</TD><TD>QTIL OU</TD><TD colspan="2">FEEDER SYSTEM</TD></TR><TR><TD align="right" height="20">838390</TD><TD align="right" class="xl63">1-Mar</TD><TD align="center" class="xl64">########</TD><TD>QTIL OU</TD><TD colspan="2">FEEDER SYSTEM</TD></TR><TR><TD align="right" height="20">838390</TD><TD align="right" class="xl63">1-Mar</TD><TD align="center" class="xl64">########</TD><TD>QTIL OU</TD><TD colspan="2">FEEDER SYSTEM</TD></TR><TR><TD align="right" height="20">838390</TD><TD align="right" class="xl63">1-Mar</TD><TD align="center" class="xl64">########</TD><TD>QTIL OU</TD><TD colspan="2">FEEDER SYSTEM</TD></TR><TR><TD align="right" height="20">842877</TD><TD align="right" class="xl63">1-Mar</TD><TD align="center" class="xl64">########</TD><TD>QTIL OU</TD><TD>C_LHE</TD></TR><TR><TD align="right" height="20">842877</TD><TD align="right" class="xl63">1-Mar</TD><TD align="center" class="xl64">########</TD><TD>QTIL OU</TD><TD colspan="2">FEEDER SYSTEM</TD></TR><TR><TD align="right" height="20">842877</TD><TD align="right" class="xl63">1-Mar</TD><TD align="center" class="xl64">########</TD><TD>QTIL OU</TD><TD>KANDY</TD></TR><TR><TD align="right" height="20">842877</TD><TD align="right" class="xl63">1-Mar</TD><TD align="center" class="xl64">########</TD><TD>QTIL OU</TD><TD>C_LHE</TD></TR><TR><TD align="right" height="20">842877</TD><TD align="right" class="xl63">1-Mar</TD><TD align="center" class="xl64">########</TD><TD>QTIL OU</TD><TD>C_LHE</TD></TR><TR><TD align="right" height="20">842877</TD><TD align="right" class="xl63">1-Mar</TD><TD align="center" class="xl64">########</TD><TD>QTIL OU</TD><TD colspan="2">FEEDER SYSTEM</TD></TR><TR><TD align="right" height="20">842877</TD><TD align="right" class="xl63">1-Mar</TD><TD align="center" class="xl64">########</TD><TD>QTIL OU</TD><TD colspan="2">FEEDER SYSTEM</TD></TR><TR><TD align="right" height="20">842877</TD><TD align="right" class="xl63">1-Mar</TD><TD align="center" class="xl64">########</TD><TD>QTIL OU</TD><TD colspan="2">FEEDER SYSTEM</TD></TR><TR><TD align="right" height="20">842877</TD><TD align="right" class="xl63">1-Mar</TD><TD align="center" class="xl64">########</TD><TD>QTIL OU</TD><TD colspan="2">FEEDER SYSTEM</TD></TR><TR><TD align="right" height="20">842877</TD><TD align="right" class="xl63">1-Apr</TD><TD align="center" class="xl64">########</TD><TD>QTIL OU</TD><TD>KANDY</TD></TR><TR><TD align="right" height="20">842877</TD><TD align="right" class="xl63">1-Apr</TD><TD align="center" class="xl64">########</TD><TD>QTIL OU</TD><TD>C_LHE</TD></TR><TR><TD align="right" height="20">842877</TD><TD align="right" class="xl63">1-Apr</TD><TD align="center" class="xl64">########</TD><TD>QTIL OU</TD><TD colspan="2">FEEDER SYSTEM</TD></TR><TR><TD align="right" height="20">842877</TD><TD align="right" class="xl63">1-Apr</TD><TD align="center" class="xl64">########</TD><TD>QTIL OU</TD><TD colspan="2">FEEDER SYSTEM</TD></TR><TR><TD align="right" height="20">842877</TD><TD align="right" class="xl63">1-Apr</TD><TD align="center" class="xl64">########</TD><TD>QTIL OU</TD><TD colspan="2">FEEDER SYSTEM</TD></TR><TR><TD align="right" height="20">842877</TD><TD align="right" class="xl63">1-Apr</TD><TD align="center" class="xl64">########</TD><TD>QTIL OU</TD><TD colspan="2">FEEDER SYSTEM</TD></TR><TR><TD align="right" height="20">838804</TD><TD align="right" class="xl63">1-Nov</TD><TD align="center" class="xl64">########</TD><TD>QTIL OU</TD><TD>KANDY</TD></TR><TR><TD align="right" height="20">838804</TD><TD align="right" class="xl63">1-Nov</TD><TD align="center" class="xl64">########</TD><TD>QTIL OU</TD><TD>KANDY</TD></TR><TR><TD align="right" height="20">838804</TD><TD>13-1</TD><TD align="center" class="xl64">########</TD><TD>QTIL OU</TD><TD>KANDY</TD></TR><TR><TD align="right" height="20">838804</TD><TD>13-1</TD><TD align="center" class="xl64">########</TD><TD>QTIL OU</TD><TD>KANDY</TD></TR><TR><TD align="right" height="20">842090</TD><TD align="right" class="xl63">1-Apr</TD><TD align="center" class="xl64">########</TD><TD>QTIL OU</TD><TD>CONNIEK</TD></TR><TR><TD align="right" height="20">842090</TD><TD align="right" class="xl63">1-Apr</TD><TD align="center" class="xl64">########</TD><TD>QTIL OU</TD><TD>CONNIEK</TD></TR><TR><TD align="right" height="20">842090</TD><TD align="right" class="xl63">1-Apr</TD><TD align="center" class="xl64">########</TD><TD>QTIL OU</TD><TD colspan="2">FEEDER SYSTEM</TD></TR></TBODY></TABLE></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Data-issue-after-exporting/m-p/99630#M755537 himabinduch 2020-11-25T16:16:04Z Re: Data issue after exporting https://community.qlik.com/t5/QlikView/Data-issue-after-exporting/m-p/99631#M755538 <HTML><HEAD></HEAD><BODY><P>Did you tried to select "Number" or " Expression Default" in the Number tab ?</P></BODY></HTML> Sat, 22 Sep 2018 16:16:12 GMT https://community.qlik.com/t5/QlikView/Data-issue-after-exporting/m-p/99631#M755538 trdandamudi 2018-09-22T16:16:12Z Re: Data issue after exporting https://community.qlik.com/t5/QlikView/Data-issue-after-exporting/m-p/99632#M755539 <HTML><HEAD></HEAD><BODY><P>Put on your dimension like that - Double Quote with space and your field name</P><P>" " &amp;[<STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Line number]</STRONG></P></BODY></HTML> Sat, 22 Sep 2018 16:53:24 GMT https://community.qlik.com/t5/QlikView/Data-issue-after-exporting/m-p/99632#M755539 rakeshkumar1890 2018-09-22T16:53:24Z Re: Data issue after exporting https://community.qlik.com/t5/QlikView/Data-issue-after-exporting/m-p/99633#M755540 <HTML><HEAD></HEAD><BODY><P>Change the format of that column to Text.</P></BODY></HTML> Sun, 23 Sep 2018 09:34:41 GMT https://community.qlik.com/t5/QlikView/Data-issue-after-exporting/m-p/99633#M755540 shiveshsingh 2018-09-23T09:34:41Z Re: Data issue after exporting https://community.qlik.com/t5/QlikView/Data-issue-after-exporting/m-p/99634#M755541 <HTML><HEAD></HEAD><BODY><P>Hey it worked for me </P></BODY></HTML> Mon, 24 Sep 2018 12:03:28 GMT https://community.qlik.com/t5/QlikView/Data-issue-after-exporting/m-p/99634#M755541 himabinduch 2018-09-24T12:03:28Z Re: Data issue after exporting https://community.qlik.com/t5/QlikView/Data-issue-after-exporting/m-p/99635#M755542 <HTML><HEAD></HEAD><BODY><P>I think, you got your result, if ok please close this thread.</P><P></P><P>also you can use it </P><P>text(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">[</SPAN><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Line number])</STRONG></P></BODY></HTML> Tue, 25 Sep 2018 03:03:01 GMT https://community.qlik.com/t5/QlikView/Data-issue-after-exporting/m-p/99635#M755542 rakeshkumar1890 2018-09-25T03:03:01Z