topic Re: Promoting a Sheet from Community to Approved in App Development

Promoting a Sheet from Community to Approved

stevedark — Fri, 09 Oct 2015 06:35:13 GMT

Hi,

As far as I can see, there is presently no mechanism to move a sheet that a user has created and promoted to the Community section of the app up into the Approved sheets. It seems to me that this should be a basic function of Sense, or there is no way of properly persisting these user created sheets, even when having to move the app back into your work area to change the script and re-publish.

Stephen Redmond posted an article on how to do this by connecting to the back end database this time last year:

Qlik Tips: Promote a Qlik Sense sheet from Community to Approved‌

Is there now a way of doing this through the front end of the app or is it likely to arrive soon?

Steve

Re: Promoting a Sheet from Community to Approved

simondachstr — Thu, 22 Oct 2015 15:52:30 GMT

Interested in this too.

Re: Promoting a Sheet from Community to Approved

stevedark — Thu, 22 Oct 2015 15:58:26 GMT

Damn. When I saw you had posted to the thread, Martin, I thought you would have some innovative work around to make it work right.

Ho hum.

Steve

Re: Promoting a Sheet from Community to Approved

simondachstr — Thu, 22 Oct 2015 16:15:06 GMT

haha,sorry for giving you false hopes - just wanted to bump this thread to ensure it's toplisted

Re: Promoting a Sheet from Community to Approved

Anonymous — Thu, 17 Dec 2015 16:08:33 GMT

Hi!

Would you have any update on that matter? The query in prod environment is not really an option as you stated.

Bests,

Re: Promoting a Sheet from Community to Approved

stevedark — Thu, 17 Dec 2015 16:35:14 GMT

I've not heard anything, but at least this thread will have bumped back to the top of the list again...

Re: Promoting a Sheet from Community to Approved

Gysbert_Wassenaar — Sat, 19 Dec 2015 07:55:15 GMT

Last I heard about a month ago from some Qlik employees is that it's not possible yet in the QMC and yes it's a glaring omission and they also ran into this and they kicked it upstairs (or downstairs, dunno where R&D lives).

Onno‌: Do you have any news about this that you can share?

Re: Promoting a Sheet from Community to Approved

oknotsen — Sat, 19 Dec 2015 12:55:22 GMT

No changes that I know of that I can or can not share, sorry.

It is a bit of a weird case, as we also discussed during the training.

Re: Promoting a Sheet from Community to Approved

Gysbert_Wassenaar — Sat, 19 Dec 2015 13:38:42 GMT

No problem. Thanks for your reply anyway.

Re: Promoting a Sheet from Community to Approved

Anonymous — Sat, 19 Dec 2015 14:27:42 GMT

Thanks for your reply!

This approved status is really a good idea thou. I hope a solution will be find quite soon because customers are a bit puzzled

Re: Promoting a Sheet from Community to Approved

Wed, 23 Mar 2016 19:17:14 GMT

We got this to work in 2.1. I used a load script with an update statement to mark the sheet approved. We found that exporting to QVF and then importing the QVF made sure everything was set correctly. Without performing the export and then import there would be problems with the app. When I make the update in the repository I also will load data from the repository in an app to make sure the Approved column is truly updated. This is working fine as well. Recently I upgraded to 2.2. Today I tried to update the Approved column and it worked but the app object is still marked as Not Approved in the QMC. I checked the data I loaded into the table chart. It shows Approved as updated. When you export from the QMC the app doesn't contain the sheets that were marked as approved. Something in 2.2 changed how objects are marked as Approved. Just updating the Approved field is working. Anyone else run into this? Anyone have any ideas as to how to fix this issue? Thanks.

Re: Promoting a Sheet from Community to Approved

Tue, 19 Jul 2016 14:11:42 GMT

This is something we'd really like to see as well and unfortunately it doesn't look like it made the cut in 3.0. I understand this can be done with a query but an update query against production really isn't a solution.

Re: Promoting a Sheet from Community to Approved

simondachstr — Wed, 20 Jul 2016 11:08:58 GMT

I strongly advise to refrain from making updates on the repository especially on multi-node server environments as they could be brought out of sync resulting in a loss of connection.

Re: Promoting a Sheet from Community to Approved

agigliotti — Mon, 29 Aug 2016 14:20:44 GMT

any news in the latest release 3.0.1 ?

Re: Promoting a Sheet from Community to Approved

Mon, 19 Sep 2016 13:41:39 GMT

I've noticed(am I'm not sure if this is a bug) that granting a user access to the resource filter App* seems to allow that user to edit base sheets of published apps but it seems dangerous as there is no "Save" functionality... changes are live. I still think community > base sheet promotions need to be implemented.

Re: Promoting a Sheet from Community to Approved

simondachstr — Mon, 19 Sep 2016 17:30:24 GMT

Agreed, doing live changes though works quite alright I must say from experience.

Re: Promoting a Sheet from Community to Approved

agigliotti — Wed, 07 Dec 2016 11:11:01 GMT

Our customer urgently needs to promote community sheet to base sheet.

Which is the quick way to achieve it ?

Re: Promoting a Sheet from Community to Approved

jaisoni_trp — Wed, 07 Dec 2016 15:53:55 GMT

Have a look at Qlik Sense QMC Utilitiesif helps

Sheet Approver

The Sheet Approver enables users to approve published sheets in an app, thus, making them base sheets of the Qlik Sense application. In addition, it's possible to un-approve sheets as well and push them back to the community.