Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

richards
New Contributor

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
mark6505
Valued Contributor III

Re: Negative value as positive values

Hi,

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

Mark
MVP
MVP

Re: Negative value as positive values

Use fabs() function....

fabs(FieldName) as FieldName
richards
New Contributor

Re: Negative value as positive values

Thanks for the answer.

 

 

 

Community Browser