How to calucalte the value using the range

[#1]

Hi techi i am new to qlikview

i have two table

Table1:

Product	Quantity Sold
A	5
A	10
A	5
B	5
B	10
B	5

Table 2:

Product	Start	End	Price
A	1	3	100
A	4	15	110
A	16	30	120
B	1	3	160
B	4	15	200
B	16	30	210

and my output should be like this

Product	Quantity Sold	Price
A	5	520
A	10	1100
A	5	600

This is how i am calculating first 5 quantity sold the total price is 520rs

(3*100)+(2*110) = 520

[swuehl]

Maybe use the solution that Sunny suggested in

how to calculate values of by a range

(and please don't post multiple threads, if you are the same person that created the other thread

It just clutters the forum with redundant posts and makes it hard to follow a discussion)

[ankitaag]

Hey,

Didn't get your output calculation.