What makes you believe that the value for Product 3 is the same as the value for Product 2? If the values are coming from a text file and empty cells always mean that the value remains the same, then you can use "Fill" transformation to fill the data at the load time.
What I'm trying to say, the answer is hiding behind the logic of populating the value for one product based on the value for another product. Once you can formulate the logic of the substitution, we can find the way of facilitating this logic in QlikView.
I know the value is the same because I've been told so. We calculate both income and volume for the products. There are numbers for income, but not volume because this productname is not used in the volumedata. For the income the product has been split into two categories.
You are right, I will have to look closer on the datamodel and figure out where the value comes from. There is a lot of excelsheets in use to map data from different systems. I guess I was just hoping for a quick fix.
Thanks for your reply!