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

Announcements
AWS Degraded - You may experience Community slowness, timeouts, or trouble accessing: LATEST 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?