How do I creating a table while filtering on Yes/No field?

[#1]

v11.2

I am new to Qlik View so forgive this basic question.  We are building charts and tables using a system already linked to the data tables in our ERP system.  Therefore, I'm not looking to create code with "Load" statements instead I am using the chart dimensions and expressions.  I am looking to select only the items with [Sold Item] = "Yes" using an expression in a chart builder.

Thank you!

[Anonymous]

Create a New Sheet Object of type List Box and select [Sold Item] as its Field.

Then in the List Box select Yes or No as per your needs.

[#3]

If you want to create Sold Item as an expression, try this

Only({<[Sold Item]={'Yes'}>} [Sold Item])

If you have any other expressions with [Sold Item], you have to use the set expression {<[Sold Item]={'Yes'}>} in all the other expression definitions also.

Regards,

KKR

[#4]

Thank you.  That did it perfectly.

[#5]

Hi Craig,

Please close the discussion if it answered your question.

Regards,

KKR