2 Replies Latest reply: Dec 24, 2013 1:38 AM by Nitin Gupta RSS

    Logic

      Dear All,

       

      In my application source of data is excel, In which there are 5 sheet with same column names.I have created a application(qvw) of 3 tab  but now due to some changes I want that my last tab will active for all the 5 excel sheet and the remaining tab works on remaining 4 excel sheet..

      So how I create logic for this in qlikview

       

      Regards ,

      Rahul

        • Re: Logic
          Stefan Wühl

          Load your excel data in with an additional field created like

           

          LOAD

               1 as SheetNo,

               ....

          FROM

          [ExcelFile.xls]

          (biff, embedded labels, table is [Tabelle1$]);

           

          LOAD

               2 as SheetNo,

               ....

          FROM

          [ExcelFile.xls]

          (biff, embedded labels, table is [Tabelle2$]);

           

          Then use this field to limit the records in your calculations:

           

          =sum({<SheetNo ={1,2,3,4}>} Value)

           

          =sum({<SheetNo ={1,2,3,4,5}>} Value)

          • Re: Logic
            Nitin Gupta

            You can also use by creating a data island for the data loaded from sheet 5.

            in this way what ever reports you wiill create with this data isaland will not effect at all on other reports.

             

             

            Regards

            Nitin