topic Export to Excel in QlikView https://community.qlik.com/t5/QlikView/Export-to-Excel/m-p/1330624#M411055 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P></P><P>Please see the file attached.</P><P></P><P>Now my problem: When I export the table to Excel, the numbers aren't formatted in the same way as they are in QlikView. Why? and how can I solve this?</P><P></P><P>What I've tried so far: Formatting Numbers within the 'Chart Properties' in the Tab 'Number' works. But I want the user to be flexible to choose which format (M or K-Values) they want to see in the table.</P><P>And I don't want to create a Column with M-Values and a column with K-Values and show and hide them with conditionals. The table I have in my project will become to large.</P><P></P><P>Thanks in advance for any ideas.</P><P></P><P>Regards,</P><P>Markus</P></BODY></HTML> Wed, 24 May 2017 12:59:41 GMT Anonymous 2017-05-24T12:59:41Z Export to Excel https://community.qlik.com/t5/QlikView/Export-to-Excel/m-p/1330624#M411055 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P></P><P>Please see the file attached.</P><P></P><P>Now my problem: When I export the table to Excel, the numbers aren't formatted in the same way as they are in QlikView. Why? and how can I solve this?</P><P></P><P>What I've tried so far: Formatting Numbers within the 'Chart Properties' in the Tab 'Number' works. But I want the user to be flexible to choose which format (M or K-Values) they want to see in the table.</P><P>And I don't want to create a Column with M-Values and a column with K-Values and show and hide them with conditionals. The table I have in my project will become to large.</P><P></P><P>Thanks in advance for any ideas.</P><P></P><P>Regards,</P><P>Markus</P></BODY></HTML> Wed, 24 May 2017 12:59:41 GMT https://community.qlik.com/t5/QlikView/Export-to-Excel/m-p/1330624#M411055 Anonymous 2017-05-24T12:59:41Z Re: Export to Excel https://community.qlik.com/t5/QlikView/Export-to-Excel/m-p/1330625#M411056 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>expression</P><P><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">=</SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">num#</SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">(</SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">NUM</SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">(</SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">sum</SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">(</SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">VAL_Sales_USD</SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">)/</SPAN><STRONG><EM><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: gray;">$(eFormat)</SPAN></EM></STRONG><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">,</SPAN><STRONG><EM><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: gray;">eDecimal</SPAN></EM></STRONG><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">)) </SPAN></P></BODY></HTML> Wed, 24 May 2017 14:59:51 GMT https://community.qlik.com/t5/QlikView/Export-to-Excel/m-p/1330625#M411056 el_aprendiz111 2017-05-24T14:59:51Z Re: Export to Excel https://community.qlik.com/t5/QlikView/Export-to-Excel/m-p/1330626#M411057 <HTML><HEAD></HEAD><BODY><P>Thanks for the answer</P></BODY></HTML> Fri, 26 May 2017 05:51:21 GMT https://community.qlik.com/t5/QlikView/Export-to-Excel/m-p/1330626#M411057 Anonymous 2017-05-26T05:51:21Z