Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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?