
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Positive and negative signs in front of numbers
Hello everyone,
I am using Waterfall Chart from Vizlib and I want +/- signs in front of my numbers.
I tried using Format pattern but it only shows me - sign, not + sign.
Am I doing something wrong here or is there any other ways to have + sign in front of numbers in the charts?
Thank you for your help!
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @su_pyae ,
Try adding your measure like this:
num(sum(Field),'+##0; -##0')
I used this with Qlik's out of the box waterfall chart and it allocated + and - correctly
Thanks
Anthony

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @su_pyae ,
Try adding your measure like this:
num(sum(Field),'+##0; -##0')
I used this with Qlik's out of the box waterfall chart and it allocated + and - correctly
Thanks
Anthony

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Anthony,
First of all, thank you for your answer. I haven't thought of using Num() to change the format before.
I am pretty sure your formula will work but it's not working in Vizlib waterfall chart.
I think it might be a bug.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @su_pyae ,
Possibly, I don't have vizlib so I can't do a direct test. There may be something in the Vizlib documentation about using the NUM() function.
Regards
Anthony

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Guess this one is impossible in Vizlib Qlik Sense.
They told me that they don't have this feature for now.
Thank you for your help, Anthony!
