integer showing as decimal with full precision when exported to excel

[#1]

Hi,

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

Can someone please tell me how to fix this

Shah

[Michiel_QV_Fan]

This is because the source data you have loaded is in that format. Integer display in the chart is display only.

Add a column in your script with number format you need and replace that in your expression.

[#3]

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.

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

Shah

[Michiel_QV_Fan · Accepted solution]

Ok.

format your expression result something like this:

round(num(sum(quantity), '#.##0'))

if you do not add a round or floor function the exported value will still be with decimals

What do you mean with: "I would like the chart export functionality only"?