Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Function for absolute values

Is there any function in QlikView Developer for absolute values like abs() in Excel?

1 Solution

Accepted Solutions
Not applicable
Author

Hi,

I thinks FABS() will help you.

- Sridhar

View solution in original post

4 Replies
Not applicable
Author

Hi,

I thinks FABS() will help you.

- Sridhar

Not applicable
Author

Great, Thank you!

Not applicable
Author

Very helpful, thanks Sridhar.

Fredrik Quirin will you pls mark this as answered so that it can help more people? Tks.

Not applicable
Author

Where Field1 is dimension

fabs(sum(Amount)/sum(TOTAL {<Amount={">=0"}>}Amount)*100)