topic Re: Num Format in QlikView

Num Format

manoranjan_d — Thu, 16 Jun 2016 07:09:47 GMT

Hi,

I have dollar value as 175082602.59 and I am dividing this with 1000000000, now i want to display it as 1.75$

how to do this num format

Re: Num Format

manoranjan_d — Thu, 16 Jun 2016 07:12:50 GMT

I using text box to show this value as 1.75$ but how to do this in num format, i used

Re: Num Format

santhoo_san — Thu, 16 Jun 2016 07:17:03 GMT

=num(175082602.59/100000000,' #0.00$')

Re: Num Format

manoranjan_d — Thu, 16 Jun 2016 07:24:00 GMT

so if if i got 111.56 then i shd add one more hash # like this '##0.00'

Re: Num Format

susovan — Thu, 16 Jun 2016 07:24:08 GMT

Hi manoranjan,

Try this,

Re: Num Format

avinashelite — Thu, 16 Jun 2016 07:39:03 GMT

As per my knowledge it will dynamically populate , try with your data and if your facing any issues let us know

Re: Num Format

nizamsha — Thu, 16 Jun 2016 08:00:57 GMT

IF u are using text object use this one

=Num(sum(175082602.59 )/10000000,'$#,##0.00')

incase if u are using any table mean go to the number format tab and click the money format and change the currencies based on the requirement

Re: Num Format

nizamsha — Thu, 16 Jun 2016 08:04:37 GMT

that will populate dynamically it depends on what you are dividing you have your data in cr so u are dividing it by cr

Re: Num Format

stevedark — Thu, 16 Jun 2016 08:11:24 GMT

Note that in the number format a hash represents a digit that might be there, whilst a zero denotes one that must be there. So, for dollar values you should use:

#,##0.00$

This will ensure two digits after the decimal, and at least one before. There will then be recurring sets of three digits separated by commas.

Hope that helps.

Steve