topic Re: KPIs from multiple dashboards in one application in App Development

KPIs from multiple dashboards in one application

bhsharm5 — Fri, 11 Aug 2023 05:05:53 GMT

Hi,

We have a requirement to create an executive dashboard taking in KPIs from 15 different dashboards.

The Background:

> There are around 40 KPIs in 15 different dashboards
> There are many users who have access to some or all the dashboards
> If they want to look at say 5 different KPIs, they will have to open say 3 to 5 dashboards
> So the need is to create an executive dashboard of shorts, which will have all the KPIs in once place
> The users will now have to open just one dashboard, to know about everything at a high level

The Requirement:

> One dashboard that shows all the KPIs in one place
> If the user wants to do further analysis, should be able to click on the KPI and navigate to the relevant detailed dashboard
> Not all users have rights to see all 40 KPIs, so a section access mechanism needs to be there so that users see only the KPIs they are authorized to

Tools at Our Disposal:

> Qlik Sense Enterprise on Windows (where all the 15 dashboards are hosted currently)
> Qlik Cloud (no apps as of now, we are just starting our Qlik Cloud journey)
> Qlik NPrinting

Appreciate if anyone could guide us on how to proceed to address this requirement.

Regards,

Bhaskar

Re: KPIs from multiple dashboards in one application

edwin — Mon, 14 Aug 2023 19:24:55 GMT

there will be multiple solutions for this. one i can thik of is for each dashboard to compute for the KPIs in the load script and write it t a QVD file. you will then have 15 QVD files with your 40 KPIs spread among them. your EIS dashboard will then read all these 15 QVDs one advantage of this approach is that your numbers will always align. but the assumption is that your KPI can be computed a load time.

another sophisticated albeit more complicated solution is to create a mashup that reads the objects in your 15 dashboards - specifically the KPIs and present it in one page (or more)

the 1st one is of course simpler

Re: KPIs from multiple dashboards in one application

mattqlikuser — Wed, 29 Jan 2025 16:22:35 GMT

Hello!

Is there more in-depth solution to this? I am running into a similar use-case and would love to know the best approach to this.

Thanks!

Re: KPIs from multiple dashboards in one application

Ciya — Wed, 29 Jan 2025 19:57:49 GMT

Hi,

even I have the similar kind of requirement.I would greatly appreciate any suggestions, ideas, or resources that could help.

Thanks in advance!