topic Re: Textbox Object value in QlikView

Textbox Object value

sunilkumarqv — Thu, 30 Jan 2014 07:16:04 GMT

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 .

Re: Textbox Object value

Anonymous — Thu, 30 Jan 2014 07:22:30 GMT

Hello,

You can use the NUM function:

Num(

Sum(Amount)

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

Hope this helps,

Quentin

Re: Textbox Object value

MK_QSL — Thu, 30 Jan 2014 07:26:58 GMT

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

Re: Textbox Object value

MK_QSL — Thu, 30 Jan 2014 07:28:28 GMT

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

Re: Textbox Object value

sunilkumarqv — Thu, 30 Jan 2014 07:37:11 GMT

Thanks

Quentin Bruno and Manish Kachhia

Re: Textbox Object value

Thu, 30 Jan 2014 07:38:21 GMT

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