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

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
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