Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

unable to easily exclude data

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

21 Replies
puttemans
Specialist
Specialist

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';


awhitfield
Partner - Champion
Partner - Champion

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

Not applicable
Author

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

Not applicable
Author

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.

chrislofthouse
Partner Ambassador
Partner Ambassador

Is this not what you want?

Not applicable
Author

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.

Picks.JPG

Steve

chrislofthouse
Partner Ambassador
Partner Ambassador

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

Not applicable
Author

Hi Chris

Sorry yes it has removed the codes.

Steve

Not applicable
Author

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.

Not applicable
Author

Thanks everyone for your help with this.