Qlikview Accesspoint doesn't capture Number Formatting from Qlikview Development

[Anonymous]

Hello ,

This is the Chart i developed in qlikview . Here the data labels on the chart shows in millions .

After i published this and open in browser , it shows like this . My number formatting goes haywire !!!

Can anybody help me on this .

Thanks .

[amit_saini]

Hi,

Try something like below and check:

=Num(sum(Sales)/1000000, '####') &' M'

Thanks,
AS

[marjan_it]

you can put your expression in num like :  num(expression, #,##0.00)

and fix the number in chart asfixed to 2 .

[Anonymous]

Hi Amit ,

Thanks for your advice .

I tried this one already  , but in my case the total amount may be in Billions , Millions & thousands also .

If I use Num function , I've to create multiple IF statements . so the RAM utilization will be more .

Is there any setting in QMC , so that it capture the same which we fix the number in chart to 2 in Qlikview Development.

[amit_saini]

Try upto 2 decimal here:

Thanks

AS

[jonathandienst]

I suspect your problem may be related to having different regional (formatting )options on your workstation and your server. Check the control panel | Region & Language | Additional Settings options on both machines.

Also make sure that the environment settings at the start of the QV script are the same - especially if you are using an include file to load them.

Failing these two, you may have some corruption in the model.

[Anil_Babu_Samineni]

I do have one question, You have y-axes is 200 but you are showing More than 200. Would it be make sense?

Usually, Your question seems visualisation problem. Why not to increase / fixed the width and height of object?

[Anonymous]

the axes is in Millions . so the chart shows correct . It is not visualization problem .

[Anonymous]

tried this but still it is same .

[marjan_it]

attach your file that we heck it.