topic Re: Remove ROW if it contains specific value in QlikView

Remove ROW if it contains specific value

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

Hello,

I'm working on a table that shows all item that we haven't shipped yet

I use the following expression

=Sum({$ <DOCUMENT_CODE={"BL"}>} PRICE/QTY_SOLD*QTY_NOT_SHIPPED)

I check all my shipping documents (BL) and compare Qty of ITEM Sold against Qty of ITEMS waiting to be shipped

It allows me to find orders that are not fulfilled yet (either in full or partially)

As you can see, we often have items with a price of 0.00 (repair under warranty, ...)

It works fine except for 1 minor issue. When sales persons add a discount, they use a specific item to do so.

This specific item keeps filling my reports as it's never removed (sold) and I can't have a clear view of my unfulfilled items

Is there a way to hide Rows containing specific value(s) ??

In my report, the elements I wish to hide have several descriptions, positions

Thank you for your help

Have nice day

Re: Remove ROW if it contains specific value

Anonymous — Mon, 03 Jul 2017 13:47:37 GMT

how is the specific item specified ?

Re: Remove ROW if it contains specific value

datanibbler — Mon, 03 Jul 2017 13:52:32 GMT

Hi Fabien,

generally yes, you do - but you will have to implement the criteria for the >>rows you do not want to show << into your dimension - you can make a flag_field in the script combining all the criteria for >>rows you do not want to show<< and use that as a second dimension and build an IF_clause into that second dimension.

There is also the possibility to add formulas on the "presentation" tab, but I'm not sure whether that works for arbitrary rows ... just give it a try.

Re: Remove ROW if it contains specific value

fgirardin — Wed, 05 Jul 2017 05:43:34 GMT

It's items from our ERP (don't know why they decided to use actual item for that purpose but I'm only the IT guy, I don't ask questions ^^)

Item N° that I'd like to remove from the table are

"Rabais final prix"

200028

200029

. (yes they use a dot as an item in our ERP.....)

The most commonly used item is "Rabais final prix" wich has always the same line position on our invoice: 8810

If I could remove this one at least, it would help a lot

I tried some "IF" conditions but it slows everything down (it's still manageable though)

Thank you for your help

Re: Remove ROW if it contains specific value

fgirardin — Wed, 05 Jul 2017 05:46:48 GMT

Hi Friedrich,

thanks for your ideas.
I'll try to add some kind of flags and see what I can do from there.

Re: Remove ROW if it contains specific value

fgirardin — Wed, 05 Jul 2017 06:01:53 GMT

I created a flag field with specific IF conditions for each Item I don't want to see then filtered this field and it works great.

Thank you