showing netive percent values in brackets - Qlik Community

kishorj1982 · ‎2017-12-11

Hi All,

PFA.

Can you please suggest how to show negative percent values in brackets upto 1 decimal place.

Thanks

jonathandienst · ‎2017-12-11

Like this:

Num(YourValue, '0.0%;(0.0%)')

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

luismadriz · ‎2017-12-11

May be this:

Num(Measure,'0.0%;[0.0%]')

I hope this helps

Luis

luismadriz · ‎2017-12-11

My bad J, you're too quick for me

jonathandienst · ‎2017-12-11

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

kishorj1982 · ‎2017-12-12

no for 66% this is showing 0.7% which is not correct.

thanks

kishorj1982 · ‎2017-12-12

no for 66% this is showing 0.7% which is not correct.