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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

1 Solution

Accepted Solutions
MayilVahanan

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

3 Replies
MayilVahanan

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.
CELAMBARASAN
Partner - Champion
Partner - Champion

As per your expression it will be like

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

or

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

Not applicable
Author

thank you!