Linking Rows with Columns

[#1]

Hey All,

I am trying to link excel rows with excel columns across sheets in QlikView, is there an easy way to do this?

For Example I have

Order #, Order Size, Bob, Jill, Kelly

200, $325, 1, 0, 1

250, $162, 0, 1, 1

and in another sheet I have:

Customer, Total Purchase Amount, Total Purchases

Bob, 1, $162

Jill, 1, $325

Kelly, 2, $487

Is there a way to link these rows with above columns? Thanks

[hector]

Hi, I made this test, and it works, check it.

I used the crosstable option when i uploaded the inline table (in my case), and use that "1" as a flag, so mi expression is Sum (OrderSize*Flag)

Good luck