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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

expression help

hi i have the following problem.

i wish to break out returns ( where only a return has been made) from sales + returns on the same receipt.

below is my dataset my desired result

Receipt         Type        Amount

1056             Return     500

1056             Return     100

1030             Return     300

ie. Result should show 300 and count for only Return rows should show 1.

i have attached a qvw to easier illustrate the issue.

Best

Brad

0 Replies