Use Master Table Field Value to build Details Table Field Value

Wed, 21 Mar 2012 09:51:39 GMT

Hi,

I would appreciate any help on the following:

* I have a Header table and a LineItems table, with the key connection between them is "HeaderGID".

Example:

Header:

HeaderGID	Multiplier
123	1
124	-1
125	0
126	1
127	-1
128	1

LineItems:

LineItemId	HeaderGID	Value
1	123	10
2	123	20
3	123	30
4	124	15
5	124	10
6	125	20
7	126	30
8	126	40
9	127	15
10	127	50
11	127	60
12	128	10

The point is that I want to add a column on LineItems with name "FinalValue" which will be the result of the multiplication of the "Value" by the "Multiplier". Hence, I want the final LineItems table to be as follows:

LineItems (Final):

LineItemId	HeaderGID	Value	FinalValue
1	123	10	10
2	123	20	20
3	123	30	30
4	124	15	-15
5	124	10	-10
6	125	20	0
7	126	30	30
8	126	40	40
9	127	15	-15
10	127	50	-50
11	127	60	-60
12	128	10	10

Any help on how can I use the associated field values of Multiplier when I load the LineItems?

Thanks in advance

Panayotis

LineItemId	HeaderGID	Value
1	123	10
2	123	20
3	123	30
4	124	15
5	124	10
6	125	20
7	126	30
8	126	40
9	127	15
10	127	50
11	127	60
12	128	10

LineItemId	HeaderGID	Value	FinalValue
1	123	10	10
2	123	20	20
3	123	30	30
4	124	15	-15
5	124	10	-10
6	125	20	0
7	126	30	30
8	126	40	40
9	127	15	-15
10	127	50	-50
11	127	60	-60
12	128	10	10

LineItemId	HeaderGID	Value
1	123	10
2	123	20
3	123	30
4	124	15
5	124	10
6	125	20
7	126	30
8	126	40
9	127	15
10	127	50
11	127	60
12	128	10

LineItemId	HeaderGID	Value	FinalValue
1	123	10	10
2	123	20	20
3	123	30	30
4	124	15	-15
5	124	10	-10
6	125	20	0
7	126	30	30
8	126	40	40
9	127	15	-15
10	127	50	-50
11	127	60	-60
12	128	10	10

topic Use Master Table Field Value to build Details Table Field Value in QlikView

Use Master Table Field Value to build Details Table Field Value

LineItemId	HeaderGID	Value
1	123	10
2	123	20
3	123	30
4	124	15
5	124	10
6	125	20
7	126	30
8	126	40
9	127	15
10	127	50
11	127	60
12	128	10

LineItemId	HeaderGID	Value	FinalValue
1	123	10	10
2	123	20	20
3	123	30	30
4	124	15	-15
5	124	10	-10
6	125	20	0
7	126	30	30
8	126	40	40
9	127	15	-15
10	127	50	-50
11	127	60	-60
12	128	10	10