Qlik Community

Qlik Sense App Development

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

Highlighted
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

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