topic Input box problem in QlikView

Input box problem

Wed, 10 Jul 2013 11:53:37 GMT

Hi,

Does someone have any suggestions or better ways how to use input box variables and display them in a table or pivot table so they matches selected dimensions inside the table?

I have a table like this:

Region Month Actual

North 1 20

North 2 25

North 3 30

South 1 10

South 2 15

South 3 10

Want to do something like this:

Target (Input box)

North_1 Variable(ex.10)

North_2 Variable(ex.15)

North_3 Variable(ex.20)

South _1 Variable(ex.5)

South _2 Variable(ex.10)

South _3 Variable(ex.15)

Region Month Target Actual

North 1 10 20

North 2 15 25

North 3 20 30

South 1 5 10

South 2 10 15

South 3 15 10

Thanks

-Johan

Re: Input box problem

Gysbert_Wassenaar — Wed, 10 Jul 2013 12:04:13 GMT

You can probably define an input field in the script instead of using N variables.

INPUTFIELD Target;

Table1:

load Region, Month, 0 as Target, Actual

from ...somewhere...;

You can then simply update the values in the Target field in charts by clicking on the value in the field and entering another value.

Re: Input box problem

Wed, 10 Jul 2013 12:44:08 GMT

Thanks for the advice Gysbert. That’s a really interesting and helpful function.