topic Is it possible to add/edit value with QV input box and button in QlikView

Is it possible to add/edit value with QV input box and button

Sat, 03 Dec 2011 22:18:24 GMT

Hello,

Is it possible for me to oftenly add/edit value in the table (which will be later used for calculations in other table) by using QV sheet objects?

This table of mine contains quite a lot of records, which is not appropriate to create each variable for each record.

Are there any other ways to adjust the data inside QV application?

Thanks a lot for your answers.........

Is it possible to add/edit value with QV input box and button

swuehl — Sat, 03 Dec 2011 22:31:07 GMT

Maybe the input fields are what you are looking for, please have a look at inputfield statement in the help, also check out inputsum and inputavg functions. There are some examples and threads covering input fields here in the forum, so search for it also here.

Hope this helps,

Stefan

Re: Is it possible to add/edit value with QV input box and button

IAMDV — Sat, 03 Dec 2011 22:37:03 GMT

Hi,

Yes, you can add the data into QlikView by using InputField Statement as prefix before the Load or Select statement. You can change these values in ListBox or TableBox objects. Once you add the prefix "InputField" to your field you can hover over the field to see an input icon. And you directly edit these field.

Please look into page 217 in QV 10 reference manual for detail information. Also, look at swuehl example in this link.

I hope this helps.

Cheers - DV

Re: Is it possible to add/edit value with QV input box and button

Sun, 04 Dec 2011 10:46:52 GMT

hello,

Thanks a lot! It works..

By the way, I found this error after reloading:

Duplicate keys when loading Input Field

The thing is that there is one table (A) with the field name "GL_Code" before.

And when I'm about load to another new table (Map) containing field "GGL_Code" and "BLS_Item"

by using both fields as input fields, the above error displayed.

Actually, "GL_Code" and "GGL_Code" reflect to the same one,

but what I need is not to let QV join both fields automatically.

I'd like GL_Code in table (A) keep the records as for their transactions,

whereas table (Map) to keep the mapping value which allows user to make adjustment usually.

How could I manage with this problem on duplicate keys?

Much be appreciated for your help!

Is it possible to add/edit value with QV input box and button

Sun, 04 Dec 2011 13:16:30 GMT

Now, i figured out that is to add RowNo() statement at the end of the field!

btw, Thanks all a lot.