This is my database
| Category | Quantity | Existing Costs |
|---|
| Car | 2 | 20000 |
| Car | 3 | 30000 |
| Ship | 1 | 100000 |
| Ship | 2 | 200000 |
how can i create an inpultfield, where a customer can manually add the quantity , which matchup in the database the quanatity column and assigns the referring existing costs.
Example
A customer is choosing car as category. He knows that the quantity for car is only 2 or 3. Now he inserts "3" as quantity in an inputfield. qlikview should now match the input "3" in the database which is deposited in the column Quantity. so if category is car and the input is 3, compare Inputfield=3 with Quantity. Find Car=Quantity=3 and return 30000 as existing cost.
