topic Number Formatting in QlikView

Number Formatting

Wed, 28 Mar 2012 15:00:59 GMT

i have a number in with say 9 digits...100000000 which is essentially 100million...how do i format this number to show £100.0m without having to divide by 1000000/

thanks

Jason Lee

Number Formatting

hic — Wed, 28 Mar 2012 19:18:39 GMT

You could for example use the dual function: first parameter is how it should look and the second is the numeric value it should have:

dual('£ ' & round(Number/1000000,0.1) & 'm',Number) as Number

/HIC

Number Formatting

Wed, 28 Mar 2012 21:09:53 GMT

1) In the Properties> number> Format Pattern settings you can select money and in the format pattern make the respective changes. In the number format settings, if you like to see for thousands symbol and what you like to see for millions symbol and in the format pattern change to £.

else

Num(field/1000000,'£ #.0 m')

Number Formatting

Wed, 28 Mar 2012 21:10:43 GMT

My answer was for the interface.

Number Formatting

Thu, 29 Mar 2012 07:40:27 GMT

thanks for this...i was wondering if this could be done without me having to divide the original number by 1000000.

Re: Number Formatting

Thu, 29 Mar 2012 08:09:45 GMT

This feature was working perfectly in QlikView 8.5: