topic Re: How do I creating a table while filtering on Yes/No field? in QlikView

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

Tue, 30 Jun 2015 16:15:02 GMT

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!

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

Anonymous — Tue, 30 Jun 2015 16:55:14 GMT

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.

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

Tue, 30 Jun 2015 17:04:51 GMT

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

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

Tue, 30 Jun 2015 18:11:31 GMT

Thank you. That did it perfectly.

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

Wed, 01 Jul 2015 07:52:20 GMT

Hi Craig,

Please close the discussion if it answered your question.

Regards,

KKR