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