topic Re: Combining Dashboards in QlikView

Combining Dashboards

cbaqir — Fri, 10 Jun 2016 18:06:59 GMT

We have several functional dashboards that span many user roles. I have a requirement to start producing role based dashboards which means taking several different sets of data and combining them to make one giant fact table and different sheets from existing dashboards and combining them into one.

Does anyone have any best practice suggestions on doing this as I get started??

Re: Combining Dashboards

marjan_it — Sat, 11 Jun 2016 04:58:47 GMT

If I understand correct you want a qw file with a lot of object and many roles that want each role see some of objects in your file?!!!

if this is you can load a filed AccessFiled in your script with the number of roles and in layout Show part make condition set. then when you define task you can set property Access Field.

Re: Combining Dashboards

Anil_Babu_Samineni — Sat, 11 Jun 2016 06:57:33 GMT

Cassandra,

As i understand, you already have one application might be you want develop one more application based on first application qvd's. Is this you are asking or different. If different, Please let us know the clarity and expected o/p?

Re: Combining Dashboards

Sat, 11 Jun 2016 23:36:57 GMT

Hi cbaqirdhds‌,

I had similar requirements. In my case, the business had multiple departments and each department was only interested in specific facts but the General managers and operations managers were interested in everything.

Here is what you can try :

Develop a QVW to generates QVD files from SQL or whatever is your source data.
Write your ETL script in a way that it creates normalised QVD files (2nd or 3rd form)
Store this QVD files in one central location

Once you have created normalised QVD files...

Create a QVW Dashboard using those normalised QVD files.
Create multiple sheets with generic names like (Summary, Trend, Comparison, Reports)
Create Section Access in the load script

So, if some one will log in from Sales will only see filters and data related to his/her department (Based on what you have granted access to during the section access)

This will save resources on server too so instead of having multiple dashboard for multiple facts, you can have one dashboard but I don not know your actual requirement so I am not sure this will fit your purpose.

Introduction to Section Access

You can provide more details of your case if my answer does not meet your need.

Good luck

Re: Combining Dashboards

marjan_it — Sun, 12 Jun 2016 04:06:04 GMT

I said this. you can do section access for every obect in your qvw file.

Re: Combining Dashboards

cbaqir — Mon, 13 Jun 2016 14:39:33 GMT

No, not quite. I have Dashboards A, B and C. I need to create Dashboard D that uses one sheet (several objects) from Dashboard A, one from Dashboard B and one from Dashboard C.

As such, the "fact" table behind these will need to be combined. The data is very different for all of these sources.

Does that help?

Re: Combining Dashboards

cbaqir — Mon, 13 Jun 2016 14:40:55 GMT

Section access is not what is needed. I need to combine data and views from several dashboards to give someone a complete picture without having to look at several dashboards (1 for sales, 1 for resources etc).

Re: Combining Dashboards

Thu, 16 Jun 2016 10:41:28 GMT

As per my limited knowledge, It would not be possible to see Resources object values in Sales Dashboard until unless that data resides in the same data model !

Have you looked into Binary load?

Re: Combining Dashboards

marjan_it — Tue, 21 Jun 2016 03:55:47 GMT

maybe this can help you

Executive Dashboard: Combining Multiple QlikView Documents into a Single Dashboard

Re: Combining Dashboards

pipuindia99 — Tue, 21 Jun 2016 07:37:51 GMT

Hi,

You can use document chaining method where you can access the new dashboard by linking with existing dashboard objects