topic Get Only Two Decimal Values For Output! in QlikView

Get Only Two Decimal Values For Output!

Mon, 30 Jan 2012 07:39:32 GMT

Hi, Consider I'm using the following expression:

=((sum(HCL_AMT_PAYABLE)/sum(HCL_CLM_AMT))*100) ... The output is 99.98956896 something

How can I limit the expression to display

values only till two decimal places (like 99.98).

Suggestions appreciated.

Regards,

Shahbaaz.

Re: Get Only Two Decimal Values For Output!

Mon, 30 Jan 2012 07:47:27 GMT

Hi,

Use this Expression,

Num((sum(HCL_AMT_PAYABLE)/sum(HCL_CLM_AMT))*100,0.00)

Thanks & Regards,

Parag Patil

Get Only Two Decimal Values For Output!

Mon, 30 Jan 2012 07:51:16 GMT

Hi Parag,

Thanks, but that does not seem to work. It shows "No data to display" irrespective of selections made.

I tried experimenting with the number format, but in vain.

Regards,

Khaled,

Get Only Two Decimal Values For Output!

jagan — Mon, 30 Jan 2012 07:58:19 GMT

Hi,

Try this

=Round(sum(HCL_AMT_PAYABLE)/sum(HCL_CLM_AMT)*100, 0.01)

Hope this helps you.

Regards,

Jagan.

Get Only Two Decimal Values For Output!

Mon, 30 Jan 2012 08:21:18 GMT

Hi Parag,

There are good solutions before my message.

But, perhaps, simply, in the properties, Number-Number Format Settings, Fixed to 2 decimals or Format Pattern #,##0.00

Pierre

Get Only Two Decimal Values For Output!

pogrebnoymike — Mon, 30 Jan 2012 08:39:41 GMT

You should still be able to use the number format, but do not forget the single quotes. Try the following:

=Num((sum(HCL_AMT_PAYABLE)/sum(HCL_CLM_AMT))*100,'#,###.##')

Get Only Two Decimal Values For Output!

kamalqlik — Mon, 30 Jan 2012 10:26:02 GMT

Hi khaledshahbaaz,

1st way---- You can go in the number tab in the chart and than go to then go to number setting formatting

set the value as--fix to 2 decimal places.

or go to the expression

2nd way---Num((sum(HCL_AMT_PAYABLE)/sum(HCL_CLM_AMT))*100,'#,###.##')

or try

Num((sum(HCL_AMT_PAYABLE)/sum(HCL_CLM_AMT))*100,'#,##0.00')

Hope this wil help you

regards

Kamal

Get Only Two Decimal Values For Output!

Thu, 16 Feb 2012 20:11:22 GMT

Hello.

Fixing the number format from the settings didn't work but yes, this expression worked.

=(((sum(HCL_AMT_PAYABLE)/sum(HCL_CLM_AMT))*100) ,0.00)

Thanks everyone..!

Regards,

-Khaled