8 Replies Latest reply: Apr 19, 2018 4:50 PM by David Forest RSS

    Linking Sheets

    Ron M

      Hello!

      I am relatively new to Qlik sense. I have 3 common sheets (namely 1,2 and 3) and all 3 have been linked to a base sheet (namely 4). I have another sheet (namely 5), which I want linked to the common sheets 1,2 and 3. Is this possible at all ? Please let me know if there is a solution to this.

       

      Thanks,

      Rony

        • Re: Linking Sheets
          Mark Ritter

          I don't quite understand what you are trying to do?  When you say linked to another sheet what do you mean exactly and what are you trying to accomplish?

          • Re: Linking Sheets
            Krishna Nagulapally

            Do you mean navigate to the other sheet from one sheet?

            • Re: Linking Sheets
              Pankaj Thakur

              Do you want to have a snapshot page with various tabs pointing to other sheets?

              • Re: Linking Sheets
                chaitanya yelisetty

                If i got your req right ..

                 

                You are showing Sheet 4 by default from which you can navigate to Sheets 1 , 2, 3 with buttons and actions by hiding the tab row ?

                 

                Now you also want the 5th sheet to work like 1, 2, 3 where you can navigate from your sheet 4 which is a base sheet. ??

                 

                If so, please include button / text objects in sheet 4 which has an action to activate sheet 5 (your new sheet).

                 

                Hope this helps

                 

                Thanks

                CY

                • Re: Linking Sheets
                  Ron M

                  Hello All!

                   

                  Thank for for your responses. Let me explain my question in a little more detail.

                  Sheet 1:Month/Year

                  Sheet 2:Customers

                  Sheet 3:Products

                  Sheet 4:Month,Year,Product and Customer Sales

                   

                  Sheet 4 has been linked to Sheets 1,2 and 3.

                   

                  Now I have sheet 5 with customer wise and month wise Budget data.

                  I want to add sheet 5 and use data of sheet 1,2,3&4 while creating graph. Pls let me know with which sheet the

                  new sheet 5 should be associated.

                   

                  As I am new to QS, I am not sure if your previous responses answered my question. Hope I have been able to explain myself better. Any help  on this is appreciated.

                  Regards,

                  Rony

                    • Re: Linking Sheets
                      Mark Ritter

                      I still don't understand what you mean by linked?

                       

                      Are you simply saying that you combined the data from the first 3 sheets and now display this on sheet 4?  Do you have screen shots to see what you are doing?

                       

                      To most of us linking sheets means using an extension or KPI to click on a value on one sheet to jump to another sheet.

                       

                      I'm not clear that is what you mean.

                      • Re: Linking Sheets
                        Naveen Bandari

                        Hello,

                         

                        First u load the data...then go to edit..this data reflect under fileds tab...then u can create which one u want like charts,Tables....

                        • Re: Linking Sheets
                          Shivanand Kamath

                          Ron,

                           

                          Qlik Sense uses associative data model and the data is available to all the sheets. When you create chart objects, they are referring the underlying tables. Each sheet does not create new tables or fields. so you cannot refer to sheet objects from one sheet to another sheet as source.

                           

                          You may want to explore master items feature if you want show same chart in different sheets.

                          • Re: Linking Sheets
                            David Forest

                            Sheets are not linked as you are describing.

                            The data for a Qlik App is available to all sheets in the app and filters applied to the data apply to all sheets.

                             

                            Now, you may be saying this is not happening with your new dataset. The new dataset/table must share the same key fields (By exact name, case matters) as the data used for Sheets 1-4. You can see if they link as expected by using the Data model viewer