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

Announcements
April 13–15 - Dare to Unleash a New Professional You at Qlik Connect 2026: Register Now!
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