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

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

changing val

Hello,

how do i change all gross data having negative data for 8 - 13 [S/N] also 1 and 3 in [S/N] from negative to positive.

Labels (1)
1 Solution

Accepted Solutions
sunny_talwar

What if you use -> fabs(Sum (GROSS))

View solution in original post

2 Replies
sunny_talwar

What if you use -> fabs(Sum (GROSS))

Kushal_Chawda

Try,

Sum(Fabs(Gross))