when you say lock on manufacturer what do you mean? Are you trying to load the data table only for a single manufacturer? Normally, you would load the entire dataset then you can use set analysis within your visualizations or measures to create one specific to a manufacturer. Or you would just use the native functionality of Qlik to allow users to filter on any manufacturer they choose.
I'm trying to make it easier on the people who are going to be using this. That means that I have to replicate something that's already been done. I uploaded a picture to show what I mean. Unfortunately it's not pretty but it needs to be that way.
One manufacturer already chosen followed by a year over year view of what's going on with that manufacturer. Those fields are called CY 2013, CY 2014, CY 2015, etc.