Not applicable
2009-07-09
03:14 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Function for absolute values
Is there any function in QlikView Developer for absolute values like abs() in Excel?
- Tags:
- functions
1 Solution
Accepted Solutions
Not applicable
2009-07-09
03:30 PM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
4 Replies
Not applicable
2009-07-09
03:30 PM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
I thinks FABS() will help you.
- Sridhar
Not applicable
2009-07-09
03:41 PM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Great, Thank you!
48,441 Views
Not applicable
2013-09-26
04:54 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Very helpful, thanks Sridhar.
Fredrik Quirin will you pls mark this as answered so that it can help more people? Tks.
48,441 Views
Not applicable
2014-02-10
09:44 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Where Field1 is dimension
fabs(sum(Amount)/sum(TOTAL {<Amount={">=0"}>}Amount)*100)
48,441 Views