topic Re: Add a new column to a table where user controls its input in QlikView

Add a new column to a table where user controls its input

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I'd like to have the user be able to control some numbers and add those numbers in my table (all go in a new column).What's the best way to do so? Should I create variables and then have an input box (then can I create a field in my table based on those variables?)

Here's the table (comes from various sources): The UserInputs column is empty just that you guys understand what I'll need to do.

ID	Criteria	Step	Numbers per each step	UserInputs
2512	cri2	1	12
2874	cri3	2	11
3290	cri1	2	3
1249	cri1	3	4
2840	cri3	1	6
1295	cri2	1	7

Re: Add a new column to a table where user controls its input

Clever_Anjos — Tue, 14 Jun 2016 17:50:39 GMT

PFA attached

Re: Add a new column to a table where user controls its input

Tue, 14 Jun 2016 18:00:46 GMT

Thanks!Can you explain more on how you've done the loading? Not sure how I can use INPUTFIELD and join to my main table

Re: Add a new column to a table where user controls its input

Clever_Anjos — Tue, 14 Jun 2016 18:02:46 GMT

You mark your field as InputField (check the script) and use the Inputsum() function

Re: Add a new column to a table where user controls its input

Tue, 14 Jun 2016 18:08:16 GMT

I've added INPUTFIELD NewField; to the beginning of my script but it doesn't show up anywhere so that I can use Inputsum function..

Re: Add a new column to a table where user controls its input

Clever_Anjos — Tue, 14 Jun 2016 18:10:01 GMT

NewField exists into your model? It must exist

Re: Add a new column to a table where user controls its input

Tue, 14 Jun 2016 18:19:07 GMT

No it doesn't, and that's one of my problems, so I'll create an empty field (or with some default values) and let the user change it. Thanks!

Now one question: Is it possible that when the user inputs the value for one record, I automatically set the same value for the other records with the same Criteria? Because All of the records that have the same Criteria need to have the same value in NewField. Not sure if it's possible?

Re: Add a new column to a table where user controls its input

Clever_Anjos — Tue, 14 Jun 2016 18:21:48 GMT

Not sure about it´s possible, I don´t use this feature regularly.

Re: Add a new column to a table where user controls its input

Tue, 14 Jun 2016 18:22:46 GMT

Thanks!:)

Re: Add a new column to a table where user controls its input

Tue, 14 Jun 2016 18:43:05 GMT

Sorry one more question: How can I make sure the user can only enter integers?

Re: Add a new column to a table where user controls its input

Clever_Anjos — Tue, 14 Jun 2016 18:48:32 GMT

I don´t think so

Re: Add a new column to a table where user controls its input

Clever_Anjos — Tue, 14 Jun 2016 18:50:17 GMT

Documentation: inputsum ‒ QlikView

Re: Add a new column to a table where user controls its input

Tue, 14 Jun 2016 18:53:32 GMT

Thanks! I have another question, but I'll ask in another thread for tracking purposes!