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

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. 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

Labels (1)
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