topic Re: Format the values on DataPoints to ###,### in QlikView

Format the values on DataPoints to ###,###

techvarun — Fri, 09 Jan 2015 10:06:23 GMT

Hello Qlixperts

Happy new year to all!!!

I want to format the value on the Data points to ###,###

I want to display 65042 as 650,42..

Please advice something to acheive the result

Thanks

Varun

Fri, 09 Jan 2015 10:09:10 GMT

Hi Varun,

you have several options, first you could use the Num() function around your expression to adjust the format to your desired output.

Num ([Expression], '###,###')

Or you can use the number tab within the chart properties.

hope that helps

Joe

morganaaron — Fri, 09 Jan 2015 10:09:32 GMT

In your expression, wrap it in the num() function and specify your desired output, so:

Num([Your Expression], '###,###')

techvarun — Fri, 09 Jan 2015 10:22:35 GMT

I have a container and 4 bar charts init, The above sollution is works fine for three charts and for one chart I am not able to Change the format

Any Idea to sort this out?

Appreciate your help

Thanks

Varun

morganaaron — Fri, 09 Jan 2015 10:23:38 GMT

What type of chart is it, and what's the expression?