Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Employee
Employee

Format numbers and 'Value on Data Points'

Hi all,

I'm building a bar chart where I need to show the values of the bars ('Value on Data Points' option). I've formatted the numbers in this way.

Capture1.JPG.jpg

The axes label changes depending on the unit, but the values don't change.

Capture2.JPG.jpg

Does anybody knows how to control the format on these numbers?

Thanks, Ferran

1 Solution

Accepted Solutions

Re: Format numbers and 'Value on Data Points'

The problem is due to fake values for dimension and expression, the chart doesn't know how to split data.

Each expression is splitted into any dimension you add, so the scale depends on this.

To format numbers go in numbers tab and set the expression with needed format.

The scale as said depends on dimension.

10 Replies

Re: Format numbers and 'Value on Data Points'

you can only set size and font for these numbers

Employee
Employee

Re: Format numbers and 'Value on Data Points'

Thanks Alessandro.

I've a trick for a chart with one dimension and one expression.

Capture3.JPG.jpg

I add a calculated dimension =0 and an expression =0.

Capture4.JPG.jpg

Capture5.JPG.jpg

The problem is that my chart has 2 expressions.

Not applicable

Re: Format numbers and 'Value on Data Points'

Can you share a sample app?

Employee
Employee

Re: Format numbers and 'Value on Data Points'

Thanks Shyamal,

I've uploaded a simple test case.

Ferra.

sunilkumarqv
Valued Contributor II

Re: Format numbers and 'Value on Data Points'

try like below in your script

hope it get solution if not we look into different way

and try to change

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

SET NumberFormat='#.##0:#.##0';

Re: Format numbers and 'Value on Data Points'

What is the problem with that document?

Why have you introduced dim and exp = 0?

Employee
Employee

Re: Format numbers and 'Value on Data Points'

Thanks Alessandro!

As you said, I initially thought that I can manage the number format using the 'Value on Data Points' option. But I discovered a trick to do it in a bar chart with one dimension and one expression. The app is just an example to show that with one dimension and one expression QlikView auto-format the numbers in the bar chart, but I can't do it with a multi-expression barchart.

Capture6.JPG.jpg

I don't know why I introduce exp = 0, but it works.

Employee
Employee

Re: Format numbers and 'Value on Data Points'

Thanks Sunil,

The result is the same :-( In my Script the decimal and thousand separators was different because of the language configuration.

Re: Format numbers and 'Value on Data Points'

The problem is due to fake values for dimension and expression, the chart doesn't know how to split data.

Each expression is splitted into any dimension you add, so the scale depends on this.

To format numbers go in numbers tab and set the expression with needed format.

The scale as said depends on dimension.

Community Browser