Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
daveatkins
Partner - Creator III
Partner - Creator III

Is it possible to allow data entry by users?

I have a dashboard which includes a list of items that need attention. End users will filter to identify the cases that need attention, then they assign a case worker to investigate further. Is it possible to use some kind of inputfield in the data model so I can allow the users to add in the name of the caseworker or check off a box that indicates this row has been assigned to someone?

13 Replies
Gysbert_Wassenaar

daveatkins
Partner - Creator III
Partner - Creator III
Author

I do not want to write back to the source database. I just want to put new data in the QlikView data model.

Gysbert_Wassenaar

That's the way you do it, write back to a file or database or whatever and then reload the qlikview document.


talk is cheap, supply exceeds demand
neelamsaroha157
Specialist II
Specialist II

May be this can help

Chip_Matejowsky
Support
Support

Yes, it is possible. I have seen some QlikView predictive analytics apps which provide data based upon end user interaction. Don't ask me how to do so, though, I'm not a developer. There should be some examples floating around in community.

Principal Technical Support Engineer with Qlik Support
Help users find answers! Don't forget to mark a solution that worked for you!
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

For immediate update of the "data model", you will need a third party extension such as Klikins.

(Note: The QV "Real Time Update" feature may be capable of doing this, but as far as I know, RTU has been deprecated by Qlik)

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

daveatkins
Partner - Creator III
Partner - Creator III
Author

this is interesting, but I do not understand what is going on by just inspecting it

daveatkins
Partner - Creator III
Partner - Creator III
Author

Thank you for the responses here, but it appears what I want is not possible--at least not for the simple implementation I am looking for. The closest solution I have found is to use inputfield, however when I enter values in the field, these values are only visible to the person who entered them, and other users are able to enter their own values for the same rows which defeats my purpose.

My purpose is to allow users to indicated when an item in a table of open cases has been assigned to a case manager. The scenarios is that I have QlikView pulling data from production systems for review by program managers who identify cases that need special attention. They assign the cases to a case manager who opens a ticket in another system. So QlikView is just the triage tool. The user flags read-only rows from an external database that is updated hourly.

I am open to the idea of a simple local database table such as an excel spreadsheet, that would have the primary key and a status, but it sounds like this would require development work "outside" Qlik. I need to create an app I can drop into a production environment without special configurations.

daveatkins
Partner - Creator III
Partner - Creator III
Author

Thanks. The QlikView is set to reload every hour. I need users to be able to enter data and have it appear immediately for other users who might be viewing the same table. The source data is read-only. So my wish is to  add a flag/status column associated with the source data rows and have the end user be able to set a value from the web browser/access point interface.