1 Reply Latest reply: Aug 9, 2016 3:34 AM by Alluraiah Allu RSS

    How to Load multiple qvw's to a single qvw.

    Ritesh Thawani

      Hi All,

       

      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.

      For ex.

      If I have QVW1,QVW2,QVW3,QVW4,QVW5,QVW6

       

      I am using this to load all QVW's into QVD.

      BINARY QVW1.qvw;

      FOR i = 0 to NoOfTables()-1

        LET vTableName = TableName($(i));

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

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

      NEXT i

       

       

      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..!!