topic Re: Input box in QlikView

Input box

Wed, 11 Feb 2015 06:28:56 GMT

I have the following table:

Sl. No.	Qty	Amount	Currency	Input box-1	Input box-2
1	9	10	EUR	CIF	2%
2	6	20	USD	CIF	3%
3	2	30	INR	CIF	5%
4	4	40	EUR	Ex-Works	7%
5	7	50	NOK	Ex-Works	1%
6	6	60	YEN	Ex-Works	8%

The Rows are not constant. i.e sometimes it will be 6 rows, sometimes 10 rows depending on the file i select.

I want an Input box or drop down box to update my choice,.

since the rows are not constant, i am not able to create a Drop-down box.

I want a solution wherein i will be able to create as many input boxes or dropdown fields wherein i can update my choice.

Can anyone help me with a solution in qlikview.

Re: Input box

krishna20 — Wed, 11 Feb 2015 07:03:57 GMT

Hi Kartik,

Create a Variable as vtop -> call the variable in Input box and take straight table-> Goto dimension Limits-> call this variable at values. or at Presentation tab-> Max No.Hope this helpful

Regards

Krishna

Re: Input box

avinashelite — Wed, 11 Feb 2015 07:04:35 GMT

Hi Kartik,

Input box can be used in two way:

1.To define the input field in the script which will make that filed as input enabled from the user

2.To create an input box object in the front end with variable and using variable as input to show the data in charts .

I have attached the example for both, according to your need please select the one which suits your requirement

Re: Input box

Wed, 11 Feb 2015 09:35:02 GMT

Dear Avinash,

Thanks.

But as mentioned earlier, the field are not constant.

For eg. you have given area as East, West , North and South and created input fields only for these four.

Assuming in the table, there are more line items like north-west, southern-east. etc,.

there will be unlimited combinations in my table.

For each and every line item, i can't create in inline coding a sperate input box.

i should define only once. and depending on the number of line items, it should create so many input boxes with different values.

Re: Input box

avinashelite — Wed, 11 Feb 2015 09:51:55 GMT

Then define the input field in the script that will meet you requirement