topic Master App That Combines Data From Other Apps in App Development

Master App That Combines Data From Other Apps

newuser — Mon, 24 Jan 2022 14:29:28 GMT

Hi - I've researched the forums and read Qlik Help on this and wanted to confirm the options: if I have multiple separate Qlik apps but want to combine the information from those apps into a single "master" app, are mashups the way to go? Alternatively, I know I could take the data from all those apps and import them into a separate master app, but that's maintaining the same data in two places.

So I believe the answer to this is mashups but wanted to confirm if there were other options out there.

Speaking of mashups, those feel similar to embedding objects in a SharePoint web part, so I'm thinking they both accomplish ultimately the same thing, just a different way (whether developing in Qlik or in SharePoint).

Thanks!

Re: Master App That Combines Data From Other Apps

Patricia_Silva — Mon, 31 Jan 2022 11:06:11 GMT

Hello @newuser, from what understand you would like to have a master app and then make selections to this one? Have you checked ODAG functionality? https://www.youtube.com/watch?v=Ft3I00-g4H4 Otherwise, please let me know if that is not your case scenario 🙂 Thank you!

Re: Master App That Combines Data From Other Apps

newuser — Mon, 31 Jan 2022 13:53:25 GMT

We have several separate apps, and what we are trying to do is create a "one-pager" of KPI's from each app. @Patricia_Silva

Re: Master App That Combines Data From Other Apps

mikaelsc — Mon, 31 Jan 2022 14:16:59 GMT

or something with this: https://github.com/ralfbecher/q-risotto

i use it to fetch data in 30 apps, that are very specific, they may have different dimension names, etc;

the "q-risotto" app fetches all data (i listed all master items that are needed), translates it to the same dimensions, and allows me to display KPI's in a single app that have very different sources. (of course, there is always some work to be done)

I don't like the mashup because of the possible different dimensions (that would require multiple selectors for example "month")

and ODAG is not what you need...

Re: Master App That Combines Data From Other Apps

chris_djih — Mon, 31 Jan 2022 14:54:58 GMT

Either you go with Mashups as you already mentioned
or you have to do some manually aggregation and use "document chaining" to link the other Apps

Re: Master App That Combines Data From Other Apps

newuser — Mon, 31 Jan 2022 15:21:41 GMT

@mikaelsc, can you send a screenshot of how the end user-facing UI looks like? Is it just like another Qlik app? And what was the setup like? Is it expensive to setup and maintain? Thanks

Re: Master App That Combines Data From Other Apps

newuser — Mon, 31 Jan 2022 15:24:29 GMT

@chris_djih, can you elaborate on what you mean by the other non-mashup option you mentioned? I will have to check into "document chaining". Is there an advantage to that option? From what I've seen, it allows you to open another Qlik app from an existing one. In our case, we are looking for a single one-pager with all KPI's across multiple Qlik apps, so that the user would not have to click around. TY!

Re: Master App That Combines Data From Other Apps

mikaelsc — Mon, 31 Jan 2022 19:48:19 GMT

it's like any other qlik app;

the only "fun" part is the script; it's like using qlik objects/master items through the rest connector

i keep the query part for each KPI in a separate text file:

it's all really well documented on the github page; but it's a few years old, and probably not maintained anymore (it survived all qlik sense upgrades ever since)

@rbecher talked about a commercial version a few years ago, it's maybe time to ask if there's news 😉 (via Vizlib or TIQ? )

Re: Master App That Combines Data From Other Apps

rbecher — Tue, 01 Feb 2022 08:59:27 GMT

@mikaelsc this still works? A PoC in production.. 😀

Re: Master App That Combines Data From Other Apps

chris_djih — Tue, 01 Feb 2022 11:10:25 GMT

Some users find mashups to complicated, since you need some kowledge of html to make the best out of it.
So there is an "alternative" that you rebuild manually all KPIs in one App, but on a highly aggregated basis - so that your datamodel don't get too big. then you use Buttons to Link (via URL) to other Apps for further Analysis.

This can be done similarly a bit more advanced using On-Demand-App-Generation as @Patricia_Silva said.

Re: Master App That Combines Data From Other Apps

mikaelsc — Tue, 01 Feb 2022 14:19:52 GMT

@rbecher

i still cannot understand no one else seems to realise how brilliant this is... not even Qlik itself :-s

are there alternatives i'm not aware of ? or is qlik so afraid of not selling a licence because of this?

(i have nprinting as failsave; but adds unnecessary complexity to the process)