Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
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
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,
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
Hi,
pheraps you could use inputfield Inputfield example.qvwor what-if analysis What If analysis.doc
Do you mean you want to input multiple items numbers for search (not adding data)?
-Rob
That is correct, searching and returning multiple lines for price review.
Thanks.
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