Qlik Community

Qlik DataMarket Discussions

Discussion Board for collaboration regarding Qlik DataMarket.

sannidhikumar
Contributor

Remove negative sign

hi ,

how to remove negative sign from field like EX: -174582 to 174582


thanks ,

pradeep

1 Solution

Accepted Solutions
vamsee
Valued Contributor

Re: Remove negative sign

Fabs( Your Expression)

10 Replies
MVP
MVP

Re: Remove negative sign

I'm not sure to understand, anyway; maybe with this format pattern in number tab

#.##0; #.##0

sannidhikumar
Contributor

Re: Remove negative sign

hi

i used that function but its not working fine any other suggestions.

thanks,

pradeep

vamsee
Valued Contributor

Re: Remove negative sign

Fabs( Your Expression)

sannidhikumar
Contributor

Re: Remove negative sign

i tried fabs but its emptying that number i need excatly like EX:-89589 red color to  remove that minus sign  to 89589 redcolor

vamsee
Valued Contributor

Re: Remove negative sign

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.

#,##0;(#,##0)

sannidhikumar
Contributor

Re: Remove negative sign

8959 should be in red .

vamsee
Valued Contributor

Re: Remove negative sign

Red can be done in visual cues.

Select the expression and upper would be >=0 lower <0

sannidhikumar
Contributor

Re: Remove negative sign

applied its a pivot table and its not working .

sannidhikumar
Contributor

Re: Remove negative sign

sorry its a pivot table and i used visual cues its not working

Community Browser