Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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.