I have below requirement , I have below commodities in my App.
I want to give user ability to enter some value in front of each of below mentioned commodities. It can be either table or any other.
Thanks for your help.
QV/QS are not designed with data entry in mind - they are reporting and discovery tools, not data capture tools.
Like you can force a round peg into a square hole, you can get QV/QS to capture data, but neither the user experience nor the reliability will be good.
Yes, this is possible, just use an INPUTFIELD.
In order to do this you first need to designate a field as an inputfield in your script. Like so...
'' as [FieldName]
FROM Data.qvd (qvd);
Then you can put that field into a straight table. Beware this will wipe your data when you reload and I believe the data you write in will be stored in either the dashboards '.shared' or '.meta' file and will be unique to that user, like an un-shared bookmark.
Just be careful how you input data, you can input into a box that doesn't display all of the component chart and it will split that values down beneath it.
For additional reading try these links for a comprehensive description...
Although, saying this, I also agree with the previous comments that QlikView isn't a great tool for data input and this solution can be a bit clunky. But, if you need the functionality, there it is!
Hope this helps,