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: 
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