Help can anyone see what is wrong with my expression?

[qlikmpate0]

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)

[tresesco]

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

Removed extra '{<'

[#3]

I think set identifier is missing.

[qlikmpate0]

I removed '{<' still does not work added an extra '}' and that doesn't work either

[ashfaq_haseeb]

Hi,

Try below.

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

If possible hare sample file.

Regards

ASHFAQ

[Marcio_Campestrini]

Hi Mina

Try this:

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

I think you missed the "$"

[qlikmpate0 · Accepted solution]

Ok thank you guys for your support I have the answer :-

Sum({<CurrentPeriodFlag = {'Y'},ORGANISATION_ID-={1020}>} SHIPPED_QTY)

[qlikmpate0]

Does the dollar include the selections in the UI doc?

[Marcio_Campestrini]

I don't think so. It's part of Set Analysis syntax.

[#10]

I see your not equivalent sign is missing the expression, you need to use <> for at the organsisation where it is not equals to 1020