Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

subtraction in set analysis

Hi All

In Set Analysis if we use match(LineNo, '1A', '1B', '1C') than all lines value will be added.

Is that possible if I want addition of '1A' & '1B' and subtract '1C' out of these? like '1A' + '1B' - '1C' in single set analysis

Something like this   

Sum({$<LineNo = {'1A', '1B'}-{'1C'}>} AMT)

Thanks

11 Replies
Anonymous
Not applicable
Author

Hi Juan

I agree with your suggestion, I had the same feeling but again curious to know if possible.

Thanks

Anonymous
Not applicable
Author

Hi Oleg

I appreciate your suggestion,

Thanks to make more clear, it helps