Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Entering data directly into table?

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 NumberList PriceCost Price
1234

10

5
45675035
891053
111296

Any suggestions would be greatly appreciated.

Thanks,

7 Replies
datanibbler
Champion
Champion

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

Not applicable
Author

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,

Not applicable
Author

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

bbi_mba_76
Partner - Specialist
Partner - Specialist

Hi,

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

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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

-Rob

Not applicable
Author

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

Thanks.

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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