QlikView App Dev

[#1]

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

[#2 · Accepted solution]

Hi,

I thinks FABS() will help you.

- Sridhar

[#3]

Great, Thank you!

[#4]

Very helpful, thanks Sridhar.

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

[#5]

Where Field1 is dimension

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