In Qlik Sense, users (with appropriate permissions) can create their own sheets. These sheets will not be seen by any other users unless the owner chooses to publish them. Once published, the sheet goes into the Community sheets area.
It may be the case that a sheet created by a user is so good that we would like to promote it to being an Approved sheet. Right now, there doesn't appear to be a supported method of doing so.
We can, however, use an unsupported method and that is simply to update the entry in the database for the Sheet object. You will need to refer to my previous post on connecting to the repository and use a Query tool (such as the one that comes with pgAdmin III).
The table that we want to update is AppObjects. You will need to write a query (or load the data into Qlik Sense!) to find out the correct ID. The Object will have Published=true and Approved=false so we just need to update the latter:
Simple as that. Once is is approved, as well as appearing in the Approved list, if you duplicate the application, the sheet will appear in the available sheets to edit.
Stephen Redmond is author of QlikView Server and Publisher and the QlikView for Developer's Cookbook
He is CTO of CapricornVentis a
QlikView Elite Partner. We are always looking for the right people to join our team.
Follow me on Twitter: @stephencredmond