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