Solved: Re: Excluded value in a table - Qlik Community

hammermill21 · ‎2017-05-11

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?

Digvijay_Singh · ‎2017-05-11

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.

View solution in original post

Anil_Babu_Samineni · ‎2017-05-11

Are you talking about Script / front end.

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

hammermill21 · ‎2017-05-11

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

Anil_Babu_Samineni · ‎2017-05-11

You can use like below

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

PS - Please pattern as per your need

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

Digvijay_Singh · ‎2017-05-11

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

Anil_Babu_Samineni · ‎2017-05-11

You may missed

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

hammermill21 · ‎2017-05-11

I used that but it's not excluding it.

Anil_Babu_Samineni · ‎2017-05-11

What is your expression?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

hammermill21 · ‎2017-05-11

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.

Anil_Babu_Samineni · ‎2017-05-11

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful