Trouble with the num() function

[#1]

Hi All,

I'm working through the Qlikview 11 for developers book. I've hit a snag, and can't see where I have gone wrong.

I'm busy with the gauge section and mine just isn't coming out right, I am adding a text in chart to display a % the script I've written is:

=Num (Sum ([# Transported Passengers]) / Sum ([# Available Seats]), '##.#%')

Which puts a % display onto my gauge, but instead of displaying 78.6% it displays 78.#%

On my second gauge I've put in this script also for a text in chart:

=Num (Sum ( [# Departures Performed] ) / Sum ( [# Departures Scheduled] ) , '##.#%' )

On this chart it displays 1,1e+002.#% instead of 110.2%

Any help with this matter would be greatly appreciated.

Also I have attached a snip of my first gauge and script.

Thanks

[oknotsen]

Did you start the file from scratch?

If so, can it be that in your part of the world you use a comma for decimals and a point for thousands (like for example the Netherlands and Belgium)? If so, check the first few SET statements of your load script and switch the point and the comma around.

[sudeepkm]

can you try '#,##0.0%'

[sasiparupudi1]

num(YourExpression,'# ##0.00%')

[Anonymous]

=num(Sum([# Transported Passengers])/sum([# Available Seats]),'##.#%')

[qlikviewwizard]

num(YourExpression,'# ###.#%')

[#7]

I found out that it only happens when I type the format pattern, but If I copy paste the format pattern from the number tab when integer is selected it works fine.

I think it might be a setting on my pc, any one else heard of this?

Thanks for all your responses!

[oknotsen]

I have seen problems with different quotes, but that would give you a clear error and does not seem to be the case here.

Are you using a special character set or language setting? In other words, something exotic far away from the "US / International" keyboard?