topic Re: Format numbers and 'Value on Data Points' in QlikView

Format numbers and 'Value on Data Points'

Ferran_Garcia_Pagans — Tue, 25 Mar 2014 11:34:31 GMT

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.

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

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

Thanks, Ferran

Re: Format numbers and 'Value on Data Points'

alexandros17 — Tue, 25 Mar 2014 11:36:30 GMT

you can only set size and font for these numbers

Re: Format numbers and 'Value on Data Points'

Ferran_Garcia_Pagans — Tue, 25 Mar 2014 11:47:34 GMT

Thanks Alessandro.

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

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

The problem is that my chart has 2 expressions.

Re: Format numbers and 'Value on Data Points'

Tue, 25 Mar 2014 11:47:51 GMT

Can you share a sample app?

Re: Format numbers and 'Value on Data Points'

Ferran_Garcia_Pagans — Tue, 25 Mar 2014 11:54:20 GMT

Thanks Shyamal,

I've uploaded a simple test case.

Ferra.

Re: Format numbers and 'Value on Data Points'

sunilkumarqv — Tue, 25 Mar 2014 12:31:20 GMT

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'

alexandros17 — Tue, 25 Mar 2014 12:31:41 GMT

What is the problem with that document?

Why have you introduced dim and exp = 0?

Re: Format numbers and 'Value on Data Points'

Ferran_Garcia_Pagans — Tue, 25 Mar 2014 12:49:04 GMT

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.

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

Re: Format numbers and 'Value on Data Points'

Ferran_Garcia_Pagans — Tue, 25 Mar 2014 12:52:02 GMT

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'

alexandros17 — Tue, 25 Mar 2014 12:54:03 GMT

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.

Re: Format numbers and 'Value on Data Points'

PrashantSangle — Tue, 25 Mar 2014 12:59:37 GMT

Hi,

Follow Simple Step;

Go to Chart Property->Number->select Expression->Select Number Format Settings

->Format Pattern->Enter #,##0;#,##0

In above format Pattern #,##0;#,##0 in this after ; it will format for -ve values,

Regards,