topic Re: Entering data directly into table? in QlikView

Entering data directly into table?

Mon, 07 Oct 2013 14:35:03 GMT

I have a straight table which looks like below (except it has thousands of rows of data).

I have Item Number as a searchable field, but wondered if there is a way of entering the Item number directly (either into the table, or via an Input box).

I need to be able to input single lines or a number of lines (normally 4 or 5 at a time) but I can't see an easy way to do this.

Item Number	List Price	Cost Price
1234	10	5
4567	50	35
8910	5	3
1112	9	6

Any suggestions would be greatly appreciated.

Thanks,

Re: Entering data directly into table?

datanibbler — Mon, 07 Oct 2013 14:39:08 GMT

Hi Paul,

short answer: That's not possible. You're not looking at Excel 😉

In QlikView, the only place where you can enter data is (usually) the script, not the GUI.

As a rule, the script is run first and then the GUI comes up - there's no way back.

There are of course ways to enter data in the GUI (like input_boxes for variables), but you cannot put data in a table like you can in Excel. There might be a way to do this, but I don't know any - haven't had this requirement yet.

HTH

Best regards,

DataNibbler

Re: Entering data directly into table?

Mon, 07 Oct 2013 14:47:28 GMT

Thanks, I thought that might be the case...

How would I do this using input boxes? Would I need a variable for Item Number (vitemnumber) and link this to my Item Number in the table?

Thanks,

Re: Entering data directly into table?

Mon, 07 Oct 2013 15:20:22 GMT

Paul

As far as I know is not posible to do what you are trying, not that way.

To insert data into the table you need to be running the script.

With input boxes you can load data into variables, and then with a macro save that to a file, so you can load it into the table, on next reload. however this is not posible from web as you can't run macros from web view.

Regards

Re: Entering data directly into table?

bbi_mba_76 — Mon, 07 Oct 2013 15:28:33 GMT

Hi,

pheraps you could use inputfield Inputfield example.qvwor what-if analysis What If analysis.doc

Re: Entering data directly into table?

rwunderlich — Mon, 07 Oct 2013 15:37:54 GMT

Do you mean you want to input multiple items numbers for search (not adding data)?

-Rob

Re: Entering data directly into table?

Mon, 07 Oct 2013 15:45:22 GMT

That is correct, searching and returning multiple lines for price review.

Thanks.

Re: Re: Entering data directly into table?

rwunderlich — Mon, 07 Oct 2013 16:06:36 GMT

Here are a couple examples for searching using pasted search strings. You can probably find a few more by searching the community for "paste search string".

Search by copy and pasting from an external list » The Qlik Fix! The Qlik Fix!

http://community.qlik.com/message/267605#267605

The extension object for Ajax referenced in the QlikFix post does not seem to exist on the community site any more. I've attached an old copy I have here for reference.

-Rob