Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
techvarun
Valued Contributor II

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

Hello Qlixperts

                       Happy new year to all!!!

I want to format the value on the Data points to ###,### Valuyes on Data point.png

I want to display 65042 as 650,42..

Please advice something to acheive the result

Thanks

Varun

1 Solution

Accepted Solutions
Not applicable

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

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.

Format.png

hope that helps

Joe

4 Replies
Not applicable

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

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.

Format.png

hope that helps

Joe

morganaaron
Valued Contributor

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

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

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

techvarun
Valued Contributor II

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

Thanks Aaron Morgan and JoeSimmons



     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
Valued Contributor

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

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