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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources 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

Use fabs() function....

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

Thanks for the answer.