topic Re: Reducing up to 2 decimal points in QlikView

Reducing up to 2 decimal points

manu1512 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Folks ,

I want to reduce the data in attached excel sheet tup to decimal points. can you please help ?

Regards

Manu

Re: Reducing up to 2 decimal points

devarasu07 — Tue, 16 Jan 2018 11:09:12 GMT

hi,

you can try like this,

let say your measure is Sales then u can write like below,

Num(sum(Sales),'#,##0.00')

Round(sum(Sales), '0.01').

Re: Reducing up to 2 decimal points

pablolabbe — Tue, 16 Jan 2018 12:05:40 GMT

Num will only mask the number to show 2 decimals, not affecting the original number.

Round with change the numbers to 2 decimal affecting further calculation.

Regards,

Pablo

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others