QlikView: Combine data from different rows in a table
Hi,
I have a table with sales and inventory balance for different products. The numbers are on different rows but I want to create a table (straight or pivot) that shows the inventory balance in every warehouse for every product a customer has ordered. I know this can be done quite easily in the script but can I do it in a table chart? The attached Excel file clarifies what I'm talking about, I have the upper table in my data model and the lower table is what I want to create (the numbers are just examples).
