Several apps, same charts, different data sources.

[darroyo_telcomu]

Hi.

Imagine this scenario: 50 customers has to access qlik dashboards. All of them want the same reports and charts, but only with their own data.

How do you manage that?

Option 1: one only app with data of all the customers. This seems dangerous. I should manage filters in order each customer see only its own data. What's more, it make no sense to load data from 50 customers and show only for one.

Option 2: 50 different apps, one app for each customer. In this scenario... the problem comes when I have to make some changes in the reports, because I would have to repeat the same changes 50 times, one for each app. Is there any way to have a "master app" or "template app" that replicate changes in the 50 apps? Or something like that?

Thanks for your attention 🙂

[Or]

You could probably set up some sort of process using Qlik's API to recognize that a certain root app has been re-published, create a copy, replace its connection string with whatever one is needed for each customer, and then replace the existing app for that customer using the modified app. It's basically what you get with Qlik development management platforms which let you push an app into different environments (reloading  and changing connections as needed during the process). 

[paulcalvet]

Hello,

You can define the perimeter in the name of the apps then retrieves the name in the script withDocumentTitle().

Ex:

Let vCustomer = DocumentTitle()

Load * from customer.qvd where customer = '$(vCustomer)';

Load * from fact where exist(customer);

Put all your script in txt file and use include() to load them, then you'll have one script for all applications.

For the deployement , the best way is to create an automation if you are in the cloud or use qlik-cli if you are on premise (with custom properties).

[darroyo_telcomu]

Thanks!

Yeah, it will solve the problem of mantaining 50 load scripts 🙂

What about the visualizations? If I need to add a new chart, a new sheet... have to insert it 50 times in the 50 apps?

[fabdulazeez]

Did you try option 1 with section access.

Were you able to find any better solution