Excluded value in a table

[hammermill21]

Hello,

I have a table that has barcodes listing along with other information. Now when the barcode is attached to a question Is this a retired barcode and the answer is yes, I want to exclude it from that table. How can I do that in Qlik Sense?

[hammermill21]

Thanks Digvijay,

currently on my expression all I have is [Bar codes], which pulls in all the barcodes. How would I go about adding that?

[Digvijay_Singh]

Try adding new measure something like as below , and then hide this column, I think there is something in properties to hide it -

Sum({<retired barcode-={'Yes'}>} 1)

[Digvijay_Singh]

If you can share qvf sample, we can see what all it needs to make it work.

[hammermill21]

I have attached it to my original message. I'm working with the table "Pending Inspections. All the ones that have a yes under Retired Barcode? I want to exclude.

[Digvijay_Singh]

I see a blank qvf, don't know if any error in attachment or something else.

[hammermill21]

I attached it again, not sure what happened there.

Thank you again for looking over this for me!!

[Digvijay_Singh · Accepted solution]

I could open it now, I thought of changing your count expression but it is dynamically generated from variable and the variables are loaded in script through variable.xls. So its not a good idea to change master measure when the need is to customize it in one table.

As a workaround I changed the Retired barcode? dimension to load only not yes values, to make it work I needed to deactivate 'allow null values' and zeroes in dimension and data properties.

If it is possible for you to use the variable expression directly in this table, it would not need to make the dimension as calculated dimension and the condition I suggested earlier can be incorporated in the measure expression.

Updated app is attached.

[hammermill21]

Makes total sense! I've used the "not match" before but thought this was different. Thank you so much for your help!!!!