Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2012-09-20 05:12 PM

Converting negative values into a positive one

Can someone please help me combine the 2 expressions below into 1?

Expression 1) =FABS(SUM([Data]))/100

Expression 2) Aggr(Sum (Data), [Test Description])

Thanks

2,883 Views
0 Likes
1 Solution

Accepted Solutions
MayilVahanan
MVP
MVP
‎2012-09-20 05:14 PM

Hi

Try like something,

Aggr(Sum (Fabs(Data))/100, [Test Description])

or

Aggr(Sum (Fabs(Data)), [Test Description])/100

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

891 Views
0 Likes
3 Replies
MayilVahanan
MVP
MVP
‎2012-09-20 05:14 PM

Hi

Try like something,

Aggr(Sum (Fabs(Data))/100, [Test Description])

or

Aggr(Sum (Fabs(Data)), [Test Description])/100

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
892 Views
0 Likes
CELAMBARASAN
Partner - Champion
Partner - Champion
‎2012-09-20 05:45 PM

As per your expression it will be like

Fabs(Sum(Aggr(Sum(Data),[TestDescription])))/100

or

Fabs(Aggr(Sum(Data),[TestDescription]))/100

891 Views
Not applicable
‎2012-09-21 08:18 AM
Author

In response to CELAMBARASAN

thank you!

891 Views
0 Likes