Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Maybe. See Write back to database via XML output or web service and Write Back to Database via ETL process (using CSV or XML).
I do not want to write back to the source database. I just want to put new data in the QlikView data model.
That's the way you do it, write back to a file or database or whatever and then reload the qlikview document.
May be this can help
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.
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
this is interesting, but I do not understand what is going on by just inspecting it
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.
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.