Commas on numeric

manoranjan_d — Tue, 03 Nov 2015 14:59:15 GMT

Hi all,

I m using the expression to get the legend inside the stack bar.

=Dual([Dimension 1]&'-'&Sum(Value),Sum(Value))

but i want commas in number ti show it, when i use number tab and selecting the numeric format to get commas i m losing the dimension 1 on the stack bar

Re: Commas on numeric

swuehl — Tue, 03 Nov 2015 15:01:17 GMT

Add the num() function to your text representation:

=Dual([Dimension 1]&'-'& Num(Sum(Value),'#,##0.0','.',','),Sum(Value))

Adapt the format code as needed.

topic Commas on numeric in QlikView

Commas on numeric

Re: Commas on numeric