topic Reducing Decimal Points in a Text Box to Zero in QlikView

Reducing Decimal Points in a Text Box to Zero

Anonymous — Tue, 25 Aug 2015 13:03:52 GMT

Hi Guys,

I imagine this is a pretty straight forward thing to fix.

I have the below expression in a text box:

='No of Products
' & Sum(TOTAL)

Which returns the below:

As you can see it is giving me back a seemingly infinite amount of decimal places, How do I get the above expression to just return 32 as the value?

Any help is greatly appreciated

Thanks,

Re: Reducing Decimal Points in a Text Box to Zero

Tue, 25 Aug 2015 13:10:32 GMT

you can go to the numbers tab, select that expression and then on the right, you can then define the field type, and optionally the number of decimal points

Re: Reducing Decimal Points in a Text Box to Zero

teiswamsler — Tue, 25 Aug 2015 13:11:21 GMT

Hi Scholar

You can use Num() function

Following is from the help menu in Qlikview

Number format

# ##0,#

#,##0.#

num( A, '0.0' ) where A=35648.375 returns:

	Setting 1	Setting 2
String	35 648 375	35648.375
Number	35648375	35648.375

num( A, '#,##0.##', '.' , ',' ) where A=35648 returns:

	Setting 1	Setting 2
String	35,648.00	35,648.00
Number	35648	35648

Re: Reducing Decimal Points in a Text Box to Zero

sasiparupudi1 — Tue, 25 Aug 2015 13:15:47 GMT

round(sum(TOTAL))

Re: Reducing Decimal Points in a Text Box to Zero

Colin-Albert — Tue, 25 Aug 2015 13:19:16 GMT

On the Document Properties, Numbers tab, you can set the default format for the TOTAL field as an integer, then all occurrences of TOTAL will be formatted as integers.

You can set defaults for all your number , date & time fields in this list

Re: Reducing Decimal Points in a Text Box to Zero

Anonymous — Tue, 25 Aug 2015 13:20:18 GMT

hi,

Please try:

Select integer in Number tab to truncate decimal places

Re: Reducing Decimal Points in a Text Box to Zero

Anonymous — Tue, 25 Aug 2015 14:43:16 GMT

This is perfect for what I need. Thank you!