Discussion Board for collaboration regarding Qlik DataMarket.
how to remove negative sign from field like EX: -174582 to 174582
Go to Solution.
Fabs( Your Expression)
I'm not sure to understand, anyway; maybe with this format pattern in number tab
i used that function but its not working fine any other suggestions.
i tried fabs but its emptying that number i need excatly like EX:-89589 red color to remove that minus sign to 89589 redcolor
Okay use money() instead of fabs
Positive numbers would be black
Negative would be in parenthesis.
-8959 would be shown as (8959)
If the measure you are working is not money then you would be able to do that in the number tab.
8959 should be in red .
Red can be done in visual cues.
Select the expression and upper would be >=0 lower <0
applied its a pivot table and its not working .
sorry its a pivot table and i used visual cues its not working