Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
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
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.
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
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!