topic System Fucntion - Input in QlikView

System Fucntion - Input

Anonymous — Sun, 04 Sep 2016 00:18:46 GMT

Hi,

I have taken the following piece of code from the reference manual:

Load

Input('Enter value', 'Input box') as v,

Recno () as r

autogenerate 3;

While executing the above function, two times the input box opens and accepts the value. But the value of r is (1,2,3) and the value of v is (1,2). My expectation is, the value of v should also be (1,2,3) because in the autogenerate, we have the value of 3. Why I am getting only (1,2) for v instead of (1,2,3)?

Thanks

Re: System Fucntion - Input

trdandamudi — Sun, 04 Sep 2016 01:20:25 GMT

Use RowNo() instead of Recno() like below:

Load

Input('Enter value', 'Input box') as v,

Rowno () as r

autogenerate 3;

Re: System Fucntion - Input

Anonymous — Sun, 04 Sep 2016 03:48:44 GMT

Hi Thirumala,

The issue is not with Recno or Rowno. The issue is why the input box opens only two times eventhough the autogenerate occurs 3 times.