Positive and negative signs in front of numbers

[su_pyae]

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!

[anthonyj · Accepted solution]

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

[su_pyae]

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. 

[anthonyj]

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

[su_pyae]

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!