2 Replies Latest reply: Jun 8, 2015 4:10 AM by Petter Skjolden RSS

    How do I access data from multiple Excel sheets from the same file?

      Hello,

       

      I am brand new to QlikSense and am trying to use an Excel document with multiple sheets. Let's call these sheets A, B, C, D, and E. Using the quick data load I was able to upload the Excel spreadsheet and I can see from looking at the Data Load Editor that the data from all the different sheets has been loaded. I want to create separate sheets in QlikSense where each sheet references a specific sheet from the Excel spreadsheet. However, when I go to create a new sheet in QlikSense, I am only given the option to show fields from either "A" or "all tables" and from experimenting some I've seen that QlikSense either only uses data from sheet A or aggregates the data from all the different sheets. How can I get QlikSense to only draw from the specific Excel sheets?


      Thanks!