Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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)

1 Solution

Accepted Solutions
Highlighted
Creator II
Creator II

Re: Help can anyone see what is wrong with my expression?

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

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

View solution in original post

12 Replies
Highlighted
MVP
MVP

Re: Help can anyone see what is wrong with my expression?

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

Removed extra '{<'

Highlighted
Not applicable

Re: Help can anyone see what is wrong with my expression?

I think set identifier is missing.

Highlighted
Creator II
Creator II

Re: Help can anyone see what is wrong with my expression?

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

Highlighted

Re: Help can anyone see what is wrong with my expression?


Hi,

Try below.

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

If possible hare sample file.

Regards

ASHFAQ

Highlighted
Specialist
Specialist

Re: Help can anyone see what is wrong with my expression?

Hi Mina

Try this:

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


I think you missed the "$"

Márcio Rodrigo Campestrini
Highlighted
Creator II
Creator II

Re: Help can anyone see what is wrong with my expression?

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

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

View solution in original post

Highlighted
Creator II
Creator II

Re: Help can anyone see what is wrong with my expression?

Does the dollar include the selections in the UI doc?

Highlighted
Specialist
Specialist

Re: Help can anyone see what is wrong with my expression?

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

Márcio Rodrigo Campestrini
Highlighted
Not applicable

Re: Help can anyone see what is wrong with my expression?

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