topic Delete Decimals in QlikView

Delete Decimals

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

hI Guys,

i'm using this formula on a text-object which is working, but i would like to remove the decimals.

Currenlty i have 128606,043806 as resuls, i would liket o have only 128606, how i can achieve this?
Thank you!!

='Actual - ' & (if(vExcludeInstrumentSales,sum({<Area-={'Area-not-available'}>}ExtendedUSD),Sum({<Area-={'Area-not-available'},Item_Category={$(vNoInstruments)}>}ExtendedUSD))/1000)

Re: Delete Decimals

tresB — Tue, 05 Sep 2017 08:59:17 GMT

Use floor() like:

='Actual - ' & Floor((if(vExcludeInstrumentSales,sum({<Area-={'Area-not-available'}>}ExtendedUSD),Sum({<Area-={'Area-not-available'},Item_Category={$(vNoInstruments)}>}ExtendedUSD))/1000))

Re: Delete Decimals

ramasaisaksoft — Tue, 05 Sep 2017 09:31:53 GMT

Hi Antonio,

just create a text box and write this

=Round(128606.043806) you will get a solution 128606 only.

else

for your expression

--> Round()

-->Floor(),

-->Purgecahr(128606.043806,.) it will returns 128606043806 (Because it will ignore the character after the , symbol)

-->Change the Field Number style should be like

Properties of that chart-->Number tab-->select that field -->Number format should be #,##

so that it will show only not the decimal values.

='Actual - ' & Round((if(vExcludeInstrumentSales,sum({<Area-={'Area-not-available'}>}ExtendedUSD),Sum({<Area-={'Area-not-available'},Item_Category={$(vNoInstruments)}>}ExtendedUSD))/1000))