Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
When exporting table from qlik sense to excel, using the new feature checking the box, the result is different with qlik sense.
In qlik sense i set a meause with 2 decimals, in the export the measure is 5 decimals.
Is there a way to fix this problem?
Thanks in advance, Matteo
The number formatting will only change display formatting, it will always hold any decimal values and doesn't round the numbers
To truly remove decimals from the results you can use Round() as below
=Round (sum(TOTALE_FATTURA),0.01)