topic how can i create an inputfield in QlikView

how can i create an inputfield

thanhphongle — Fri, 20 May 2016 11:46:17 GMT

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.

Re: how can i create an inputfield

t_moutault — Fri, 20 May 2016 11:49:17 GMT

Hi,

you can use a select list based on the field "Quantity".

Re: how can i create an inputfield

avinashelite — Fri, 20 May 2016 11:56:35 GMT

check this threads

Inputfield example.qvw

https://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Scripting/Input_Fields.htm

Re: how can i create an inputfield

thanhphongle — Fri, 20 May 2016 11:56:36 GMT

can u give me an example how i can use the expression?

Re: how can i create an inputfield

t_moutault — Fri, 20 May 2016 12:09:46 GMT

take a look at this