Textbox Object value

[sunilkumarqv]

     Hi all,

   I have  text box  expession sum(Amount) ,so my value is 292.0356565 .I want only Integer values  292 ,I realy appriciate would clear this solution .

[Anonymous · Accepted solution]

Hello,

You can use the NUM function:

Num(

  Sum(Amount)

,  '# ##0', '', ' ')

Hope this helps,

Quentin

[MK_QSL]

NUM(Sum(Value),'# ##0')

[MK_QSL]

Please refer to QlikView Manual....

num(expression [ , format-code [ , decimal-sep [ , thousands-sep ] ] ] )

The num function formats the expression numerically according to the string given as format-code. Decimal separator and thousands separator can be set as third and fourth parameters. If the parameters 2-4 are omitted, the number format set in the operating system is used.

Example:

The examples below assume the two following operating system settings:

	Default setting 1	Default setting 2
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

num( pi( ), '0,00' ) returns:

	Setting 1	Setting 2
String	3,14	003
Number	3.141592653	3.141592653

[sunilkumarqv]

Thanks

Quentin Bruno and Manish Kachhia

[#6]

Hi,

To erase the decimal part, you can use

Floor(Sum(Amount))

To get the nearest entire value, you can use

Round(Sum(Amount))

Hope this helps