Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
mario-sarkis
Creator II
Creator II

Set analysis


hey All

my question is  i have this fields

Currency       amount

001                1000

002                1500

003                1500

004                2000

005                1000

006                 500

i need to do the summation of amount with condition the currency has to be diffrent then 001 and 002

Sum({<Currency <>{'001','002'}>}Amount) this isn't work

Thank you hope you can help

10 Replies
sasiparupudi1
Master III
Master III

Hi

Are you still having an issue with your requirement, if yes, please share a qvw so that  we can help you

Sasi