Merging two qlikview dashboards in one

[#1]

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

[Anonymous]

Joseph

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

Best Regards,     Bill

[#3]

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?

[Anonymous]

Joseph

Aaah !!

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

Best Regards,     Bill

[#5]

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?

[#6]

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

[Anonymous]

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

[#8]

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?

[Anonymous]

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

[sudeepkm]

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.