8 Replies Latest reply: Sep 20, 2017 8:40 AM by pradosh thakur RSS

    Uploading data in different sheets

    NEVILLE DHAMSIRI

      Hi

       

      I have same data model which are in different sheets but relation to different centers such as centre A, B ,C etc. but same dimensions & expressions. Can I load the data in different sheets at once if so what steps to be followed. Appreciate if explained steps by steps!

       

       

      Regards

       

      Neville

        • Re: Uploading data in different sheets
          NEVILLE DHAMSIRI

          Please, Help me on this

           

          Regards

           

          Neville

          • Re: Uploading data in different sheets
            Gysbert Wassenaar

            Data is not uploaded in sheets. Data is loaded into the data model. There can only be one data model in a Qlik Sense app or Qlikview document. After loading the data it can be shown in chart and table objects (and other objects) on sheets.

             

            The obvious way to deal with different centers A, B and C is to select the center you wish to see. You can use a filter pane (Qlik Sense) or a List box (Qlikview) with the field that contains the center values as dimension.

            • Re: Uploading data in different sheets
              NEVILLE DHAMSIRI

              Dear Gisbert,

               

              Please see my small data array. 1st one (EM,EM1,EM2) in one sheet in excel & the other two RA, & KW  goes in other two sheets. If I load this file, will the data in all three sheets be loaded?. I loaded but always the selected sheet data only loaded. I need data from all three sheets to be loaded once.

               

              Please see whether this is possible.

               

              Regards

               

              Neville

               

              BRANCH    PROFITS   

              EM    500   

              EM1    250   

              EM2    350   

                     

                     

              BRANCH    PROFITS   

              RA    500   

              RA1    250   

              RA2    350   

                     

                     

              BRANCH    PROFITS   

              KW    500   

              KW1    250   

              KW2    350   

              • Re: Uploading data in different sheets
                Peter Alao

                Depends on how you want your data.

                From your data model below:

                BRANCH    PROFITS 

                EM    500 

                EM1    250 

                EM2    350 

                     

                     

                BRANCH    PROFITS 

                RA    500 

                RA1    250 

                RA2    350 

                     

                     

                BRANCH    PROFITS 

                KW    500 

                KW1    250 

                KW2    350 

                 

                I will simply load in this format:

                Sheet 1: Branch A

                LOAD

                Branch as Branch

                Branch as BranchA

                FROM ...

                 

                Sheet 2: BranchB

                LOAD

                Branch as Branch

                Branch as BranchB

                FROM ...

                 

                Sheet 3: BranchC

                LOAD

                Branch as Branch

                Branch as BranchC

                FROM ...

                 

                Why I loaded in duplicates is so that you have a key that connects all in your data model. From this you can do calculations on all segments at once or if you choose do individual data exploration with the duplicates

                 

                Regards

                Peter