Use Set analysis logic as filter

[gbedford]

Hello, I have created a set analysis expression that sums sales when an order (Base Order ID)  includes a M/B in the Category id.

Sum({$<Base_OrderID=P({$<CategoryID={'M/B'}>})>}NetSales)

I would like to use the logic as a filter selection.  Is this possible.  How do I do it?

Thanks.

[sunny_talwar]

Not sure I understand completely? So you want to take the set analysis out of the expression and create a filter where you make a selection?

[harishicon]

Not fully understandable . Do u want to apply this set expression in filter or what?

If yes then not possible in qliksense.

[miguelbraga]

Hi there Greg,

Don't understood totally your issue, but it seems that you want a filter of Base_OrderID when is equal to P({$<CategoryID={'M/B'}>})? If not, please elaborate your question. Hint: make a doc file with screenshots and/or your desired output.

Hope it helps

Regards,

MB

[gbedford]

Hi All, looks like I did not explain very well.  My apologies.

My data is structured so that Base_OrderID ties all the lines on an order together.  I would like to be able to filter so that I select all the Base_OrderID that include a M/B.  So, filter would select 10123, 10124 but not 10125.  I want to be able to do some basket size analysis so want all lines in order regardless of category to be selected. 10123 has 4 lines and 20124 has 3 lines.

Hope this clarifies.  Thanks.

[sunny_talwar]

Your expressions seems to be working for me