topic Re: Excluded value in a table in QlikView

Excluded value in a table

hammermill21 — Wed, 25 Nov 2020 16:16:04 GMT

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?

Re: Excluded value in a table

Anil_Babu_Samineni — Thu, 11 May 2017 16:46:04 GMT

Are you talking about Script / front end.

Re: Excluded value in a table

hammermill21 — Thu, 11 May 2017 16:59:46 GMT

The front end, since I want that data for certain parts. It's just that in the table I need to exclude it.

Re: Excluded value in a table

Anil_Babu_Samineni — Thu, 11 May 2017 17:05:42 GMT

You can use like below

Sum({<BarCode -= {'01234'}>}Sales)

PS - Please pattern as per your need

Re: Excluded value in a table

Digvijay_Singh — Thu, 11 May 2017 17:06:06 GMT

May be In your expressions, you can add set expression like - Sum({<retired barcode-={'Yes'}Value) to exclude records with retired barcode = 'Yes'.

Re: Excluded value in a table

Anil_Babu_Samineni — Thu, 11 May 2017 17:08:39 GMT

You may missed

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

Re: Excluded value in a table

hammermill21 — Thu, 11 May 2017 17:14:16 GMT

I used that but it's not excluding it.

Re: Excluded value in a table

Anil_Babu_Samineni — Thu, 11 May 2017 17:15:13 GMT

What is your expression?

Re: Excluded value in a table

hammermill21 — Thu, 11 May 2017 17:17:41 GMT

I took it all off trying to fix it, but to start with all I had was [Bar Code] which just pulls in all the barcodes data.

Re: Excluded value in a table

Anil_Babu_Samineni — Thu, 11 May 2017 17:19:50 GMT

In fact, We are expecting atleast expression or application could help more for you

Re: Excluded value in a table

hammermill21 — Thu, 11 May 2017 17:22:33 GMT

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?

Re: Excluded value in a table

Digvijay_Singh — Thu, 11 May 2017 17:28:29 GMT

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)

Re: Excluded value in a table

Digvijay_Singh — Thu, 11 May 2017 17:29:42 GMT

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

Re: Excluded value in a table

hammermill21 — Thu, 11 May 2017 17:49:53 GMT

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.

Re: Excluded value in a table

Digvijay_Singh — Thu, 11 May 2017 18:55:16 GMT

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

Re: Excluded value in a table

hammermill21 — Thu, 11 May 2017 18:58:28 GMT

I attached it again, not sure what happened there.

Thank you again for looking over this for me!!

Re: Excluded value in a table

Digvijay_Singh — Thu, 11 May 2017 19:33:06 GMT

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.

Re: Excluded value in a table

hammermill21 — Fri, 12 May 2017 12:05:37 GMT

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