Discussion Board for collaboration on QlikView Scripting.
Hi Folks ,
I need to covert all negative numbers in my pivot table to () for example -8.3 should appear as ()8.3. Any idea how to do it.
At present my number format is #.##0,0
Thanks in Advance.!!!
Solved! Go to Solution.
As Alan said, modify your number format.
expression for >0 number ; (semi colon) expression for < 0 numbers
so you will have:
num(your exp, '#,##0.0;(#,##0)', '.', ',')
Please mark the answer as Correct and also any other helpful answers, it will help other users find the answers they are looking for too