number format issue 54'3'210

Tue, 12 Jun 2012 11:43:32 GMT

Hi
Wanted to show an additional item in a bar popup using an expression without the "Bar" ticked but with a set "Text as Pop-up".
Value appeared in popup without label (dispite providing a label value with the expression) but I found a discussion item that told to add the Label into the expression
e.g. ='Label = ' & sum(value)
With this I lost the number format set in the Numbers section for the expression (which I can understand as I do not provide a number as value).
Tried to format the number myself using
='Label = ' & num(sum(value),'#''##0') // note: 2 single quotes in single quoted #''##0

Now I get the number formatted as : 54'3'210 which looks to me like unexpected??

In addition, had quite a few fights with bar charting and the limited options with providing a COOL Popup window.
Using the first expression for dimension limit only I lost formatting on Y-Axis. Getting that in place again by ticking "Value on Data Points" I ended up with a mismatch in bar color and legend color by not using first expression as a bar value (solved paritially by assigning background color to the expressions, partially because I have now static colors on expressions and dimension groups won't work as before).
Thanks for more help, Juerg

Re: number format issue 54'3'210

Anonymous — Tue, 12 Jun 2012 11:49:07 GMT

What happens when you try:

Num(sum(Value), '#.##0')

Or if it is Money try:

Money(sum(Value))

Re: number format issue 54'3'210

swuehl — Tue, 12 Jun 2012 11:51:09 GMT

You want the single quote as thousand separator?

Try

num(sum(value),'#'&chr(39)&'##0','.',chr(39))

Re: number format issue 54'3'210

Tue, 12 Jun 2012 13:00:15 GMT

Hi
I am on a swiss german machine and my Thousend Symbol is the single quote..

using '#.##0' results in 543210.##0

Juerg

topic Re: number format issue 54'3'210 in QlikView

number format issue 54'3'210

Re: number format issue 54'3'210

Re: number format issue 54'3'210

Re: number format issue 54'3'210