How to select sales order containing selected item code from a listbox (in AND logic)

[agigliotti]

Hi,
I'd need to select the sales orders that contains the selected item code from a listbox.
Ex. if the user selects item code 100 and 200 from the listbox, then the expected result should be the sales order that contains both item code that is 100 AND 200.
Could someone help me to achieve it?
Many thanks in advance for your time.

Best Regards

@vinieme12 

@sunny_talwar  @hic @stevedark @Gysbert_Wassenaar @rubenmarin @Thiago_Justen_ @Anil_Babu_Samineni @kaushiknsolanki @marcus_sommer @tresesco  

[agigliotti]

It still doesn't works, errors in expression.

[RsQK · Accepted solution]

Are you using Sense, if so which version? I did this on Aug2022 version. I literally copied and pasted the formula which i posted earlier - it should work. I will attach the .qvf here.

[agigliotti]

Hi @RsQK ,

I was trying in the latest version of QlikView v12.70  and it give me expression error.

I just tried with Qlik Sense and It works as expected.

Great Job!

Many thanks for your collaboration.

Best Regards

[agigliotti]

I tried again in QlikView and the expression does works even if the expression editor gives an error!
It makes sense because QIX engine is the same.

Best Regards