Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team i am new to qlikview
I have two table like this
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 |
can You help me in sorting this
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)