topic Re: integer showing as decimal with full precision when exported to excel in QlikView https://community.qlik.com/t5/QlikView/integer-showing-as-decimal-with-full-precision-when-exported-to/m-p/760861#M270698 <HTML><HEAD></HEAD><BODY><P>the problem is that after summing or aggregating the number, I would like to have the final value as an integer. If I convert the field to integer before aggregation, it changes the result a lot.</P><P></P><P>Is there no way to force the measure to be an integer value while exporting? Also, I would like the chart export functionality only. creating custom export macro is not an option</P><P></P><P>Shah</P></BODY></HTML> Thu, 18 Dec 2014 11:40:15 GMT 2014-12-18T11:40:15Z integer showing as decimal with full precision when exported to excel https://community.qlik.com/t5/QlikView/integer-showing-as-decimal-with-full-precision-when-exported-to/m-p/760859#M270696 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a measure in a chart which I have changed to number in the number property of the chart. It is showing as number in Qlikview. However, when I export it to excel, it shows a decimal number with full precision instead of an integer</P><P></P><P>Can someone please tell me how to fix this</P><P></P><P>Shah</P></BODY></HTML> Thu, 18 Dec 2014 11:26:11 GMT https://community.qlik.com/t5/QlikView/integer-showing-as-decimal-with-full-precision-when-exported-to/m-p/760859#M270696 2014-12-18T11:26:11Z Re: integer showing as decimal with full precision when exported to excel https://community.qlik.com/t5/QlikView/integer-showing-as-decimal-with-full-precision-when-exported-to/m-p/760860#M270697 <HTML><HEAD></HEAD><BODY><P>This is because the source data you have loaded is in that format. Integer display in the chart is display only.</P><P>Add a column in your script with number format you need and replace that in your expression.</P></BODY></HTML> Thu, 18 Dec 2014 11:36:50 GMT https://community.qlik.com/t5/QlikView/integer-showing-as-decimal-with-full-precision-when-exported-to/m-p/760860#M270697 Michiel_QV_Fan 2014-12-18T11:36:50Z Re: integer showing as decimal with full precision when exported to excel https://community.qlik.com/t5/QlikView/integer-showing-as-decimal-with-full-precision-when-exported-to/m-p/760861#M270698 <HTML><HEAD></HEAD><BODY><P>the problem is that after summing or aggregating the number, I would like to have the final value as an integer. If I convert the field to integer before aggregation, it changes the result a lot.</P><P></P><P>Is there no way to force the measure to be an integer value while exporting? Also, I would like the chart export functionality only. creating custom export macro is not an option</P><P></P><P>Shah</P></BODY></HTML> Thu, 18 Dec 2014 11:40:15 GMT https://community.qlik.com/t5/QlikView/integer-showing-as-decimal-with-full-precision-when-exported-to/m-p/760861#M270698 2014-12-18T11:40:15Z Re: integer showing as decimal with full precision when exported to excel https://community.qlik.com/t5/QlikView/integer-showing-as-decimal-with-full-precision-when-exported-to/m-p/760862#M270699 <HTML><HEAD></HEAD><BODY><P>Ok.</P><P></P><P>format your expression result something like this:</P><P></P><P>round(num(sum(quantity), '#.##0'))</P><P></P><P>if you do not add a round or floor function the exported value will still be with decimals</P><P></P><P>What do you mean with: "<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">I would like the chart export functionality only</SPAN>"?</P></BODY></HTML> Thu, 18 Dec 2014 11:43:50 GMT https://community.qlik.com/t5/QlikView/integer-showing-as-decimal-with-full-precision-when-exported-to/m-p/760862#M270699 Michiel_QV_Fan 2014-12-18T11:43:50Z