Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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
MVP
MVP

Use fabs() function....

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

Thanks for the answer.