topic Re: Input Box in QlikView

Input Box

Tue, 11 Dec 2012 01:45:58 GMT

Hi All,

I'm currently exploring the capabilities of the input box of qlikview.

Here are my objects and fields:

1. Input box

2. List box: Month,Year

3. Pivot or Straight Table: Values

Input box/field = [input number]

Month = Jan, Feb, March, ..., Dec

Year = 2011, 2012

Table:

Date	Value	Input Field
1/2/2011	10	x
2/2/2011	3	x
4/1/2012	5	x
5/2/2012	5	x

Is it possible if I select a Mont [March], and then I input in the Input box = 5

It will populate only 5/2/2012 in the input field with the value 5.'

And let's say it is month end for a specific date, the inputted fields will be locked

and only the dates up to date are the only one can be edited.

Thanks 😃

-Donna

Re: Input Box

sujeetsingh — Tue, 11 Dec 2012 04:59:53 GMT

How can it give when you are having two values for 5 4/1/2012/ and 5/2/2012.

Can you please send a sample?

Re: Input Box

Tue, 11 Dec 2012 05:36:23 GMT

Hi,

Those values are only examples. What I wanted to do is, select a specific month & year, and when I input a value in the input box, it will reflect in the specific field in the table.

e.g:

Input Box (Value) = 12/12/12

Month (selected) = May

Year Selected = 2012

output:

Date	Value	Input Field
1/2/2011	10	x
2/2/2011	3	x
4/1/2012	5	x
5/2/2012	5	12/12/12

Re: Input Box

sujeetsingh — Tue, 11 Dec 2012 06:17:20 GMT

So when you will use input box there will be a variable and thwn you just call that variable in your output table or chart in its expression.

Hope it helps!!

Re: Input Box

Tue, 11 Dec 2012 06:48:45 GMT

It will still effect the other fields. Even though I have filtered the output and typed in the input box, when the filtering is cleared, it shows that the input field is still inputted in the other values.

Re: Input Box

sujeetsingh — Tue, 11 Dec 2012 07:08:55 GMT

PLz post a example or sample

Re: Input Box

Tue, 11 Dec 2012 09:17:59 GMT

I still need to create a sample. Maybe i'll be able to post it later.

Re: Input Box

sujeetsingh — Tue, 11 Dec 2012 10:23:42 GMT

No issue