Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Input box problem

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

2 Replies
Gysbert_Wassenaar

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.


talk is cheap, supply exceeds demand
Not applicable
Author

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