Qlik Community

Qlik Sense Integration, Extensions, & APIs

Discussion board where members can learn more about Integration, Extensions and API’s for Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
johann_bauer
New Contributor III

Number Format // amCharts extension

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.

2017-08-22 10_22_56-AsBorder.png

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.

accordion.png

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

Tags (1)