Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
richards
Contributor III
Contributor III

Negative value as positive values

Dear all!

I´m having a case that the orignal data that is loaded is both positive and negative values.

How could I write my expression so that the negative values are loaded as positve values. i.e. no "-" Before the value.

Do anyone have a solution?

Best regards

3 Replies
Mark_Little
Luminary
Luminary

Hi,

On load use the Fabs() function like below.
Fabs(Field) as Field.

Mark
sunny_talwar

Use fabs() function....

fabs(FieldName) as FieldName
richards
Contributor III
Contributor III
Author

Thanks for the answer.