My (owned) sheets disappear when I duplicate a published app in QS Enterprise

[Mauritz_SA]

Hi everyone

I have a question regarding My Sheets in Qlik Sense Enterprise. When I have an app that has published (Base sheets) sheets and I create new sheets they are created under the My sheets section. Is there anyway I can get these sheets duplicated with the app when I move it to my Work stream? Below is what I have for the app in the stream:

View of all the sheets when the app is in the stream.

It seems like they just vanish (even though I am the owner (I have also tried doing this after publishing them to Sheets published by me)):

Sheets after I duplicate app to my Work stream.

The primary reason why I want to do this is because I want to create some variables in the app (which I know I can do in the unpublished app and then republish), but what if I want to create new master items from complex formulas and especially visualisations? Will I need to rebuild those visualisations to make them Master Items?

Hope someone can give some Insight .

Regards,

Mauritz

[Levi_Turner · Accepted solution]

Let's take a published app, it can have the following elements:

1. Base Content (Sheets, bookmarks, stories)
2. Community Content (Sheets)
3. Private Content (Sheets, bookmarks, stories)

When duplicating (1) is duplicated. When doing a publish and replace, Qlik Sense replaces the set described in (1) with whatever is in the app being published on top of the published app. (2) and (3) are expected to be unaffected by publish and replace operations.

[Mauritz_SA]

Hi Levi

Thanks for the reply - I am always very impressed by how helpful the Qlik employees are on the forums. What would the steps be to get the sheets in 2 and 3 in my duplicated app in my work stream? Should I Publish and Approve them, duplicate the app and then Unapprove them and  Unpublish them in the original app? Main reason for this is when I want to get some of my QS Enterprise apps in QS desktop.

Regards,

Mauritz

[Levi_Turner]

No worries. There isn't a good method to achieve this. You can import the physical binary from the Share Path > Apps (check QMC > Service Cluster for that path). The reason this isn't a good method is numerous:

• It'll break all thumbnails and images used
• It collapses 1-3 into a flat file without ownership metadata. So for a single user, this is fine. But let's imagine a prod app with 100 users creating content. You'll get a ton of sheets / bookmarks / stories).

[Mauritz_SA]

Great, thanks Levi!