Solved: Converting negative values into a positive one - Qlik Community - 427253

Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.

Skip to main content

Qlik.com | Qlik Services | Qlik Help

Ask a Question

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

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

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.

As per your expression it will be like

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

or

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

Author

thank you!