Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have a list of product codes I want to exclude from my report as this data is not relevant.
I have tried using a mapping load but that didn't work. I have tried linking in an extra table and that hasn't worked either. Even using the product code field as a list box and excluding the codes from there still does not amend the charts and graphs.
Ideally I would like to exclude the data in the script but that is proving harder than I thought.
I have attached the qvw file and a list of the products I am trying to exclude. They all have the same StockSANAL code of BEVA so I have tried to exclude that as can be seen in the qvw file. Excluding this data will make a massive difference to the Ave. TU per pick graph as these products are picked in the tens of thousands which is what causes the spike. So removing them would bring that bar more in line with the weeks around it.
Any help appreciated.
Steve
Hi there,
Seems then that your product list is not exhaustive enough, and that there are more products in your guns table than in your products table. If all BEVA products start with BV, you could try to add the following at the end :
Where
Type = 'Pick' or Type = 'NonFIFOPick' and exists(ProductCode) and left(ProductCode, 2) <> 'BV';
I was slight off here! Thinking again, the BV.. codes don't get excludde from the Products load because the don't have a BEVA StockANAL associated with them, create a table box with StockANAL and ProductCode and you'll see what I mean! They all come up as NULL StockANAL..
Andy
Hi Andrew
Both QVDs attached. I have checked and the BV codes in the original spreadsheet attached have the BEVA StockSANAL associated with them.
Steve
Thanks Johan but unfortunately not all products with the StockSANAL of BEVA start BV so that would only exclude a percentage of the stock codes.
Is this not what you want?
Hi Christopher
Unfortunately not, no. Upon opening this has messed up all of the graphs and text boxes that were reporting correctly.
This is all wrong now.
Steve
Hi Steve,
Charts aside, has it excluded the product numbers you were trying to exclude?
As you will know it's important we get the data right first and then charts. It may that I've accidently altered a field name etc.
Chris
Hi Chris
Sorry yes it has removed the codes.
Steve
Hi Chris
Just been reading back through and I have missed this somehow. Just put this in and it's worked a treat. Thanks.
Excluded another couple of items that don't need to be counted and the report is looking good now.
Thanks for your help.
Steve.
Thanks everyone for your help with this.