Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikmpate0
Creator II
Creator II

Help can anyone see what is wrong with my expression?

I'm trying to sum all shipped_qty where the organisation is not equal to 1020 and the curret period flag is equal 'Y'

=Sum({< CurrentPeriodFlag = {'Y'},{<ORGNAISATION-={'1020'}>} Invoice_Details.SHIPPED_QTY)

12 Replies
qlikmpate0
Creator II
Creator II
Author

rajesh, I have used -= as '<>' was not working

agomes1971
Specialist II
Specialist II

Will this work?

Sum({< CurrentPeriodFlag = {'Y'}, ORGANIZATION-={'1020'}>} [Invoice_Details.SHIPPED_QTY])

Kind regards

André Gomes

qlikmpate0
Creator II
Creator II
Author

could I sum shipped qty and ordered qty in the same expression?