Number Format // amCharts extension

johann_bauer — Tue, 22 Aug 2017 08:30:30 GMT

Hello Guys,

I have a question about formating a number. Im using this expression to format my number into a specific format.

num(Sum({<"WF.Position"={1}>}[WF.VALUE]),'#,##0.##')

This works fine in all Qlik Sense visualizations.

Im currently using amCharts extension, to create a waterfall viz.

As you can see in the picture above, my start Value has the wrong format.

I tried using the expression i posted above, but it looks like the start Value isnt affected by this expression.

This is how the settings look like.

The Number format for the "Position" works fine, but i dont have an option to change it for the start Value of the Waterfall.

Because of that i tried to us the above stated expression.

Is there a way a can manipulate the extension to get the right number format?

This is the code which is used for the Item" Waterfall Start"

var waterfallStart = {

type: "number",

label: "Start value for waterfall",

ref: "qDef.waterfall.start",

expression: "always",

defaultValue: 0,

show: function(m) {

return m.qDef.amGraph.type == 'Waterfall';

}

};

Regards

Johann

topic Number Format // amCharts extension in Integration, Extension & APIs