I have just started using Qlikview and I am facing a problem.
I have 6 QVW's(based on different regions) and I want to load all of them to a single consolidated report.
I am using binary load and then a loop to load all qvw's to 6 respective QVD's as suggested on previous posts on same context.
If I have QVW1,QVW2,QVW3,QVW4,QVW5,QVW6
I am using this to load all QVW's into QVD.
FOR i = 0 to NoOfTables()-1
LET vTableName = TableName($(i));
LET vOutfile = '$(vTableName).qvd';
STORE [$(vTableName)] INTO [$(vOutfile)] (qvd);
The problem is when I am Loading this in script,instead of loading QVD for different regions,It is loading QVD's of different Tabs in one QVW.
For ex- if QVW1 has three tabs in script Tab1,TAb2,Tab3. It is creating three QVD's TAB1.qvd,tab2.qvd etc,
Can someone please help me with the correct solution of this.
Thanks in advance..!!