topic Re: Merging two qlikview dashboards in one in QlikView

Merging two qlikview dashboards in one

Thu, 14 Nov 2013 09:41:01 GMT

Hi all,

I want to do the following thing and trying to find out what the best way to do it would be: I have 2 separate dashboards (single tab) that I would like to merge them in one qlikview file, which will have a page with a selection button for which one you would like to see. Any ideas?

Thanks in advance

Re: Merging two qlikview dashboards in one

Anonymous — Thu, 14 Nov 2013 09:43:29 GMT

Joseph

I normally find navigating by selecting tabs simple enough and End Users used to Excel find it intuitive.

Best Regards, Bill

Re: Merging two qlikview dashboards in one

Thu, 14 Nov 2013 10:23:59 GMT

Hi Bill,
I am actually trying to load the data directly from the 2 qvw files but it's complaining when trying to load the second one. It says

Unknown statement

Binary c:\users...

You know why?

Re: Merging two qlikview dashboards in one

Anonymous — Thu, 14 Nov 2013 10:26:03 GMT

Joseph

Aaah !!

Are you using a Binary Load ? If so then one can only Binary Load one qvw in a script.

Best Regards, Bill

Re: Merging two qlikview dashboards in one

Thu, 14 Nov 2013 10:41:47 GMT

You got it right! So I can do this for the first qvw file, but then what can I do with the second one? I dont have access to the original data anymore? Can I create qvd files for its tables without reloading/losing the data?

Re: Merging two qlikview dashboards in one

Thu, 14 Nov 2013 10:43:36 GMT

Just did it using this scipt:

FOR i = 1 to NoOfTables()

LET vTableName = TableName($(i)-1);

LET vOutfile = '$(vTableName).qvd';

STORE [$(vTableName)] INTO [$(vOutfile)] (qvd);

NEXT i

Re: Merging two qlikview dashboards in one

Anonymous — Thu, 14 Nov 2013 10:44:58 GMT

Joseph

You'll need 2 separate qvw's each with a single binary load in and then in each one store the data you want to qvd's.

Best Regards, Bill

Re: Merging two qlikview dashboards in one

Thu, 14 Nov 2013 10:50:28 GMT

Thanks Bill I have all data in now. The problem is that the original qvws have a certain structure and several tabs each one after all. Is there any chance I can copy the whole structure (and all sheets) of a qvw file to another at once?

Re: Re: Merging two qlikview dashboards in one

Anonymous — Thu, 14 Nov 2013 10:56:03 GMT

Joseph

Assuming you are referring to the dashboard sheet, then

In the new dashboard create a blank sheet
In the original dashboard sheet, <Ctrl>A then <Ctrl>C
In the new dashboard blank sheet, <Ctrl>V

Best Regards, Bill

Re: Merging two qlikview dashboards in one

sudeepkm — Thu, 14 Nov 2013 11:12:02 GMT

There are couple of approaches to this to achieve. I was working on a dashboard which was actually integration of 4 different QVWs. The approaches would be like below:

1. Using navigation from one QVW to another using button action. All the QVWs will have same header with list of buttons to navigate to each other.

2. To bring all the script from multiple QVWs and prepare the data model in a single QVW. You will have data islands per respective QVWs. You may have to take special care while implementing it. You may have to rename many of the fields (if applicable). On the Front end or UI you have to use show hide conditions or multiple sheets to present each of the QVWs content.

Re: Merging two qlikview dashboards in one

Thu, 14 Nov 2013 11:36:12 GMT

Hi Bill,

This is not what I am looking for in this case as we are talking about complex layouts with several sheets, conditional objects according to variables etc.

The manual work would be:

create all sheets
create all variables
show all objects in each original sheet

copy paste all into the sheet in new file

Re: Merging two qlikview dashboards in one

Anonymous — Thu, 14 Nov 2013 11:41:51 GMT

Joseph

In the QV Desktop, have you looked at in the QV Desktop:

File | Export | Export Document Layout

Best Regards, Bill

Re: Merging two qlikview dashboards in one

saumyashah90 — Thu, 14 Nov 2013 11:43:35 GMT

1)You can open on QlikView application from other on a click.

2)You can Merge the script of two dashboard. i.e. using Binary load

remember a)UI cannot be merged but only data model or design

b)Variable made also wont be copied,need to define the variable again

Re: Merging two qlikview dashboards in one

Thu, 14 Nov 2013 11:45:11 GMT

Hi Joseph,

Please try below one.

Create one button and call the action "Qlikview Document" in any one of the document.

Regards,

Santhosh G

Re: Merging two qlikview dashboards in one

Thu, 14 Nov 2013 11:45:18 GMT

I did export the layout but the import layout option in the new one is grayed out.

The new one is currently a blank sheet but all the data is there using one binary qvw load and several qvd loads of the tables of the second original qvw.

When I try to see how import layout works in a completely new/blank file, it expects a layout.xml file as input but I have a list of several xml files (probably one per object) and no layout.xml file

Re: Merging two qlikview dashboards in one

saumyashah90 — Thu, 14 Nov 2013 11:47:41 GMT

that the feature of binary load,

UI is never copied.

Only data comes

Re: Merging two qlikview dashboards in one

Anonymous — Thu, 14 Nov 2013 11:48:31 GMT

Joseph

I'd suggest you open a new on Layout Export / Import & close this thread as it is diverting and getting confusing.

Re: Merging two qlikview dashboards in one

Thu, 14 Nov 2013 11:48:39 GMT

so there is no way I can copy the UI along with variables and everything?

Re: Merging two qlikview dashboards in one

Thu, 14 Nov 2013 11:50:56 GMT

As per my knowledge to import the variables there is no method instead of creating.

Re: Merging two qlikview dashboards in one

saumyashah90 — Thu, 14 Nov 2013 11:52:58 GMT

No Joseph,

You have to define it again after you load...and for UI

you can select all. i.e. ctrl+A and ctrl+v which ever sheet you need to paste