Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

number format issue 54'3'210

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

1 Solution

Accepted Solutions
swuehl
MVP
MVP

You want the single quote as thousand separator?

Try

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


View solution in original post

3 Replies
Anonymous
Not applicable
Author

What happens when you try:


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

Or if it is Money try:

Money(sum(Value))

swuehl
MVP
MVP

You want the single quote as thousand separator?

Try

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


Not applicable
Author

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

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

Juerg