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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set expressions

Table A
S.nocodeDoc.codeTotal
1ILE100120
2ILE100240
3ILE100330
4ILE100450
5ILE100580
Table B
s.nocodeRef codeRef Doc codeTotal
1SRLEILE100220
2SRLEILE100440
3SRLEILE100580

hI above are my two tables .

table A is invoice  and table B is sales return.

i need to find the sum of sales by subtracting the second table . as if sales return has been done it wont be consider as profit.

how can i achieve this in expression. please help

Thanks

Vignesh

0 Replies